Study plan

• Plan generated by SQL Navigator is placed in the database

• spool d:\intradoc\plan_ok139_c.txt

• SELECT lpad(' ', 2*(level - 1)) ||

• operation || ' ' ||

• options || ' ' ||

• object_name || ' ' || optimizer ||

• decode (id, 0, ' Cost = ' || position)

• "Query Plan"

• FROM plan_table

• START WITH id=0 and STATEMENT_ID = 'OK139_C'

• CONNECT BY PRIOR id = parent_id and STATEMENT_ID = 'OK139_C';

• spool off

Notes: