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:
“A certain kind of rich man afflicted with the symptoms of moral dandyism sooner or later comes to the conclusion that it isn’t enough merely to make money. He feels obliged to hold views, to espouse causes and elect Presidents, to explain to a trembling world how and why the world went wrong. The spectacle is nearly always comic.”
—Lewis H. Lapham (b. 1935)
“I began revolution with 82 men. If I had [to] do it again, I do it with 10 or 15 and absolute faith. It does not matter how small you are if you have faith and plan of action.”
—Fidel Castro (b. 1926)