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