What is EXPLAIN PLAN statement?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is EXPLAIN PLAN statement?
Rating:
The EXPLAIN PLAN statement is used for displaying execution plans selected by the optimizer for various Data Markup Language (DML) statements. The results from executing the EXPLAIN PLAN statement can be used for determining the logic of the optimizer in choosing a particular plan. The results of EXPLAIN PLAN can also be used for analyzing the performance of a query and the logic of the optimizer in choosing a particular data structure while executing a query.
Rating:
Was this information helpful?
Other articles
- What is pinning?
- How to create an explain plan using the EXPLAIN PLAN FOR statement?
- How to setup the AUTOTRACE utility?
- What is a Database Resource Manager (DRM)?
- What are index-organized tables (IOT)?