query plan

The step-by-step route the database has chosen to answer a query: which tables to read, in what order, and with which indexes.

In more detail

EXPLAIN shows it. The plan depends on the schema, the indexes, statistics about the data and the database version, so it is evidence about today's data, not a permanent promise. Recheck it when the data distribution changes.

Related terms

Taught in

References