Query plan
Section titled “Query plan”A query plan is the sequence of physical operations a database chooses to produce the result of a query.
A plan can include table or index scans, join algorithms, sorting, aggregation, and estimated row counts. Cost-based planners compare candidate plans using statistics.
Reading the chosen plan helps distinguish an expensive access path from a slow application pattern.
Used in DKKB
Indexes and query planningUse indexes to turn scans into targeted lookups, and understand how the query planner decides whether an index helps.
Related knowledge
Indexes and query planningUse indexes to turn scans into targeted lookups, and understand how the query planner decides whether an index helps.