执行计划的另外一种看法。(原)

explain plan for
selec ........；

select * from table(dbms_xplan.display)
test了一下：

SQL> explain plan for select count(*) from hr_employee t;

Explained

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
-----------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
-----------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 2 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | INDEX FAST FULL SCAN| PKY_EMPLOYEE | 4409 | | 2 |
-----------------------------------------------------------------------
Note: cpu costing is off, PLAN_TABLE' is old version

10 rows selected

SQL> explain plan for select count(*) from inv_transactions_log ;

Explained

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost |
------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | |
| 1 | SORT AGGREGATE | | | | |
| 2 | TABLE ACCESS FULL | INV_TRANSACTIONS_LOG | | | |
------------------------------------------------------------------------------
Note: rule based optimization, PLAN_TABLE' is old version

10 rows selected

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/700806/viewspace-925268/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/700806/viewspace-925268/