CSE Roadmap

Core tier · about 3 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Write CREATE INDEX for a single column and for more than one column together.
  • Give a practical first-pass rule for deciding whether a column is worth indexing.
  • Explain, at a glance, why an index speeds up a WHERE or JOIN but not every query.
  • Point to where this subject covers an index's internal structure in full depth.

This is a first, practical pass at indexes, written from the SQL side: how to create one, and a rough sense of when to bother. Level 5 is where the actual data structure behind an index, and its real trade-offs, get covered properly.