The BEST way to generate an explain plan is via SQL*PLUS. This is because it gives all the important information: explain plan formatted nicely, statistics about the query, and timing of the query.
Quick & Easy way to Generate An Explain Plan Using Autotrace
Log into SQL*PLUS (not TOAD or any other Tool)
Issue (copy & paste)
set autotrace traceonly explain statistics;
set timing on
set linesize 250
column PLAN_PLUS_EXP format A200
execute the query as normal
Turn off autotrace be issuing after you are done
set autotrace off
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment