My Work
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
search engine
Custom Search
No comments:
Post a Comment