Glossary: SQL Beyond the Basics
Multi-column index
Also written: composite index
An index on several columns, such as (customer_id, order_date). It helps queries that filter on the first column, or the first and second, but not on the second alone.
Glossary: SQL Beyond the Basics
Also written: composite index
An index on several columns, such as (customer_id, order_date). It helps queries that filter on the first column, or the first and second, but not on the second alone.