Oracle 11g R2 全表扫描成本计算(非工作量模式-noworkload)(三)

2014-11-24 18:15:48 · 作者: · 浏览: 2
ce
SQL> select count(*) from test;


Execution Plan
----------------------------------------------------------
Plan hash value: 1950795681


-------------------------------------------------------------------
| Id | Operation | Name | Rows | Cost (%CPU)| Time |
-------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 193 (0)| 00:00:03 |
| 1 | SORT AGGREGATE | | 1 | | |
| 2 | TABLE ACCESS FULL| TEST | 1000 | 193 (0)| 00:00:03 |
-------------------------------------------------------------------


与计算的Cost相匹配,从实验种可以得出,在11gR2中,全表扫描计算Cost的方式依然和9i/10g一样,没有变化。