CSE Roadmap

Core tier · about 2 hours · 5 parts

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.