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.