Explain plan

November 7th, 2012
set autotrace traceonly statistics
set autotrace traceonly explain

explain plan for select * from user_table;
select plan_table_output from table(dbms_xplan.display('plan_table', null, 'serial'));
Comments are closed.