Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain what a composite index is, and how it orders its multiple columns.
- Explain why column order in a composite index determines which queries it can help.
- Explain what a covering index is, and why it can avoid touching the table at all.
- Decide the right column order for a composite index given a query pattern.
Every index so far in this level has covered a single column. Real queries often filter on several columns at once, or filter on one column while needing several others back. This page covers both of those common cases.