Four questions on choosing an index and reading what the optimiser did with it: which column order a composite index needs, when a table scan is the right plan, and what makes an index unusable for a query that looks like it should match.

Where to go from here

Longer reading about this subject, written alongside the course.

Course guide