Wednesday, August 27, 2008

Oracle Explain Plan with script

Create the plan table if it does not already exist
-- 9i or earlier
@?\rdbms\admin\utlxplan.sql
-- 10g or above
@?\rdbms\admin\catplan.sql

Explain Plan Syntax
set autotrace on
EXPLAIN PLAN
SELECT column_names FROM table;







No comments:

search engine

Custom Search