필요한 스크립트
$ORACLE_HOME/rdbms/admin/utlxplan.sql 실행
SQL> explain plan
set statement_id = 'lab1' for
select *
from emp
where empno = 7777;
SQL> select id
, lpad(' ',2*level)||operation
||decode(id,0,' Cost = '||position)
||' '||options
||' '||object_name as "Query Plan"
from plan_table
where statement_id = 'lab1'
connect by prior id=parent_id
start with id=0;
결과
ID Query Plan
---------- --------------------------------------------
0 SELECT STATEMENT Cost =
1 TABLE ACCESS BY INDEX ROWID EMP
2 INDEX UNIQUE SCAN PK_EMP