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: Explain 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)
“Consider any individual at any period of his life, and you will always find him preoccupied with fresh plans to increase his comfort. Do not talk to him about the interests and rights of the human race; that little private business of his for the moment absorbs all his thoughts, and he hopes that public disturbances can be put off to some other time.”
—Alexis de Tocqueville (1805–1859)