How to create an explain plan using the EXPLAIN PLAN FOR 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.
How to create an explain plan using the EXPLAIN PLAN FOR statement?
Rating:
steps involved in creation of an explain plan using the EXPLAIN PLAN FOR statement are as follows:
- Create a table PLAN_TABLE by executing the utlxplan.sql script at the location
- Populate the table PLAN_TABLE with the execution plan for the statement by using the EXPLAIN PLAN FOR statement.
Rating:
Was this information helpful?
Other articles
- What does the Log File Parallel Write event of the V view indicate?
- What is a cluster ?
- What is user global area (UGA)?
- How does Instance Manager kill a session causing lock contention?
- What is high water mark?
