09 February 2011

explain plan easy!

EXPLAIN PLAN FOR SELECT * FROM MYTABLE;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);