Esc
↑↓ navigate   Enter open   Esc close

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

  • Index — A database structure that speeds up read queries on a column at the cost of extra storage and slightly slower writes.

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.

Practice in exercises → Browse all words

Frequently Asked Questions

What does "Query Plan" mean?

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

How do you pronounce "Query Plan"?

"Query Plan" is pronounced /ˈkwɪəri plæn/.

Can you use "Query Plan" in a sentence?

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