在pl/sql developer中，直接寫條sql，按F5，就可以調(diào)出執(zhí)行計(jì)劃，但在只有sql plus的情況下，只能用下面這個(gè)語句了，
explain plan for select ....
然后再來一句
select * from table(dbms_xplan.display());
就會(huì)出現(xiàn)一個(gè)類似下面的信息
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
----------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
----------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | |
| 1 | NESTED LOOPS | | | | |
| 2 | TABLE ACCESS FULL | AC01 | | | |
| 3 | TABLE ACCESS BY INDEX ROWID| AB01 | | | |
| 4 | INDEX UNIQUE SCAN | PK_AB01 | | | |
----------------------------------------------------------------------------
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Note: rule based optimization, PLAN_TABLE' is old version
就能看到執(zhí)行計(jì)劃了。
我的微博
http://t.sina.com.cn/1401900445