InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Would You Go About Generating An Explain Plan? |
|
Answer» 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. 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. |
|