An index built from a combination of multiple columns.
An index built by combining multiple columns, where the order of the columns has a big effect on query efficiency. It follows the leftmost-prefix rule: the index is only usable when a query's conditions match its columns starting from the left. An index built on (A, B), for instance, can be used for a search on A alone, but not for one on B alone.
© 2026 ITBGM