EXPLAIN and Reading Execution Plans

The previous two chapters covered how indexes work and how to design them for different query patterns. But creating an index doesn't guarantee the database will use it.

EXPLAIN is the tool that shows you exactly what the database plans to do with your query, which scan types it picks, how it joins tables, and where it spends the most time.