An index on two or more columns. MySQL can use a composite index for queries that filter on the leftmost prefix of the indexed columns. Proper column order in a composite index is critical for query performance.
