How would you go about generating an EXPLAIN plan?
ORACLE Interview Questions and Answers (Part 5)
(Continued from previous question...)
745. How would you go about generating an EXPLAIN plan?
Create a plan table with utlxplan.sql.
Use the explain plan set statement_id = 'tst1' into plan_table for a SQL statement
Look at the explain plan with utlxplp.sql or utlxpls.sql
(Continued on next question...)
Other Interview Questions