Databases & SQL

Query Plan

/ˈkwɪəri plæn/

Definition

The execution strategy chosen by the database engine showing which indexes and operations it will use for a query.

Example in context

"Run EXPLAIN ANALYZE before and after adding the index — the query plan shows a seq scan changing to index scan."

Related terms

Practice this term

Master Query Plan in context by working through exercises in the Databases & SQL module. You'll see the term used in real engineering scenarios with multiple-choice, fill-in-the-blank, and matching drills.