Explain Plan
A query plan (or query execution plan) is an ordered set of steps used to access or modify information in a SQL relational database management system. This is a specific case of the relational model concept of access plans.
Since SQL is declarative, there are typically a large number of alternative ways to execute a given query, with widely varying performance. When a query is submitted to the database, the query optimizer evaluates some of the different, correct possible plans for executing the query and returns what it considers the best alternative. Because query optimizers are imperfect, database users and administrators sometimes need to manually examine and tune the plans produced by the optimizer to get better performance.
Read more about Explain Plan: Generating Query Plans, Database Tuning, Query Tuning
Famous quotes containing the words explain and/or plan:
“Your children get a lot of good stuff out of your work...They benefit from the tales you tell over dinner. They learn from the things you explain to them about what you do. They brag about you at school. They learn that work is interesting, that it has dignity, that it is necessary and pleasing, and that it is a perfectly natural thing for both mothers and fathers to do...Your work enriches your children more than it deprives them.”
—Louise Lague (20th century)
“some little plan or chart,
Some fragment from his dream of human life,
Shaped by himself with newly-learned art;”
—William Wordsworth (1770–1850)