Friday, 2 November 2012

How would you go about generating an EXPLAIN plan? | Oracle 10g Interview Questions

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

No comments: