composite index

An index on several columns in a fixed order, which serves queries on a leading prefix of those columns.

In more detail

An index on (customer_id, ordered_on) helps WHERE customer_id = 3, and that filter sorted by ordered_on, but not a filter on ordered_on alone. Put the column you filter by equality first.

Related terms

Taught in

References