[ORACLE] Oracle9i 실행계획 보기

필요한 스크립트
$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