Oracle explain plan

先將要解釋的sql用explain plan for作解釋

explain plan for
[sql statement]

然後顯示最後一條用explain plan解釋的結果

select * from table(dbms_xplan.display);

或為explain plan加上id方便查找

explain plan
set statement_id = 'my_id'
for
[sql statement]

然後在plan table中查找

select * from plan_table where statement_id='my_id'