Just a quick note for myself. I used to generate explain plan from sqlplus using autotrace, it's time to switch to use dbms_xplan package instead. Well it's never too late to do the right thing anyway.
SQL> explain plan for select empno,sal from emp;
Explained.
SQL> select * from table(dbms_xplan.display);
No comments:
Post a Comment