先將要解釋的sql用explain plan for作解釋
explain plan for
[sql statement]
explain plan for
[sql statement]
explain plan for [sql statement]
然後顯示最後一條用explain plan解釋的結果
select * from table(dbms_xplan.display);
select * from table(dbms_xplan.display);
select * from table(dbms_xplan.display);
或為explain plan加上id方便查找
explain plan
set statement_id = 'my_id'
for
[sql statement]
explain plan
set statement_id = 'my_id'
for
[sql statement]
explain plan set statement_id = 'my_id' for [sql statement]
然後在plan table中查找
select * from plan_table where statement_id='my_id'
select * from plan_table where statement_id='my_id'
select * from plan_table where statement_id='my_id'
