Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Run
EXPLAINon a query and identify whether it performed a full scan or an index lookup. - Read the key fields of an execution plan: scan type, estimated rows, and cost.
- Spot a query that should be using an index but is not.
- Use an execution plan to decide whether a proposed index actually helped.
Every page in this level has described what should happen when an index exists. This closing page covers how to check whether it actually happened, since assuming an index is being used, without verifying, is a common and avoidable mistake.