SQL Plan

http://download.oracle.com/docs/cd/B19306_01/server.102/b28051/tdppt_sqlid.htm#BJEEHAEC
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9010.htm#SQLRF01601

SQL>  @?/rdbms/admin/utlxplan.sql

SQL>
explain plan for
select * from employee
where user_id = '1';

SQL>
select * from plan_table;

SQL>
SELECT LPAD(' ',2*(LEVEL-1))||operation operation, options, 
object_name, position 
    FROM plan_table 
    START WITH id = 0 
    CONNECT BY PRIOR id = parent_id
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License