Entries categorized as Generating an EXPLAIN plan

Generating an EXPLAIN plan

On June 19, 2009 / By admin / In Oracle / No Comments
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 Read More...