Part 03 · Indexing

Composite, Covering and Partial Indexes

An index on (user_id, created_at) helps some queries and not others. Column order, covering indexes with index-only scans, and partial indexes for hot subsets.

⏱ 6 min · Station 23 of 123