This content has been marked as final. Show 2 replies
Do you want to see "Explain Plan" of the query?
in SQLPlus if you set
SET AUTOTRACE ON
you will see details of your statement after it executed.
or you can use EXPLAIN PLAN method doesn't require the query to be run; just type EXPLAIN PLAN FOR YOUR_STATEMENT and than execute utlxpls.sql
EXPLAIN PLAN FOR SELECT * FROM emp e, dept d WHERE e.deptno = d.deptno;
Are you looking for this place http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14220/sqlplsql.htm#sthref3460
in concepts manual?