CSE Roadmap

Core tier · about 2 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Run EXPLAIN on 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.