Query Plan

noun

say it: “KWEER-ee PLAN” /ˈkwɪri ˈplæn/

The steps a database chooses to run a query, such as which index to use, shown by tools such as explain().

What is Query Plan in a relational database?

Query Plan — A representation of the operations selected or considered for a query.

In a sentence

  • “The query plan showed the database reading every order.”
  • “MongoDB tries the indexes that could serve a query and keeps the fastest query plan.”

Level: Freelancer · More Database terms at this level

Updated