Generating Query Plans
A given database management system may offer one or more mechanisms for returning the plan for a given query. Some packages feature tools which will generate a graphical representation of a query plan. Other tools allow a special mode to be set on the connection to cause the DBMS to return a textual description of the query plan. Another mechanism for retrieving the query plan involves querying a virtual database table after executing the query to be examined. In Oracle, for instance, this can be achieved using the EXPLAIN PLAN statement.
Read more about this topic: Query Plan
Famous quotes containing the words query and/or plans:
“Such condition of suspended judgment indeed, in its more genial development and under felicitous culture, is but the expectation, the receptivity, of the faithful scholar, determined not to foreclose what is still a question—the “philosophic temper,” in short, for which a survival of query will be still the salt of truth, even in the most absolutely ascertained knowledge.”
—Walter Pater (1839–1894)
“The important thing about travel in foreign lands is that it breaks the speech habits and makes you blab less, and breaks the habitual space-feeling because of different village plans and different landscapes. It is less important that there are different mores, for you counteract these with your own reaction- formations.”
—Paul Goodman (1911–1972)