Explain Plan在sqlplus中使用起来非常的便捷,使用方法如下
sec@ora10g> explain plan for select count(*) from t;
Explained.
sec@ora10g> select * from table(dbms_xplan.display());
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------
Plan hash value: 2966233522
-------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8407 (1)| 00:01:41 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| T | 3017K| 8407 (1)| 00:01:41 |
-------------------------------------------------------------------
9 rows selected.
sec@ora10g> explain plan for select count(*) from t;
Explained.
sec@ora10g> select * from table(dbms_xplan.display());
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------
Plan hash value: 2966233522
-------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 8407 (1)| 00:01:41 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| T | 3017K| 8407 (1)| 00:01:41 |
-------------------------------------------------------------------
9 rows selected.