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)
“Man you ought to see his plans for allsteel buildins. He’s got an idea the skyscraper of the future’ll be built of steel and glass. We’ve been experimenting with vitrous tile recently... crist-amighty some of his plans would knock you out... He’s got a great sayin about some Roman emperor who found Rome of brick and left it of marble. Well he says he’s found New York of brick an that he’s goin to leave it of steel... steel an glass.”
—John Dos Passos (1896–1970)