os:win 2003 server 64bit
oracle:11.2.0.1 64bit
t_name:sim_event partition by (end_time) one day one partition
columns:200+
rows:8KW+
index: IND_SIM_EVENT_L_ETIME on sim_event (end_time) local
sga:1G
sql >select count(*) from sim_event where END_TIME BETWEEN TO_DATE('2013-06-02 00:00:00','yyyy-MM-dd HH24:mi:ss') AND TO_DATE('2013-08-03 23:59:59','yyyy-MM-dd HH24:mi:ss') ;
执行计划
----------------------------------------------------------
Plan hash value: 3336469572
-------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
-------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 11 | 62444 (2)| 00:12:30 | | |
| 1 | SORT AGGREGATE | | 1 | 11 | | | | |
| 2 | PARTITION RANGE ITERATOR| | 85M| 896M| 62444 (2)| 00:12:30 | 2 | 55 |
|* 3 | INDEX FAST FULL SCAN | IND_SIM_EVENT_L_ETIME | 85M| 896M| 62444 (2)| 00:12:30 | 2 | 55 |
-------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - filter("END_TIME">=TIMESTAMP' 2013-06-02 00:00:00' AND "END_TIME"<=TIMESTAMP' 2013-08-03 23:59:59')
统计信息
----------------------------------------------------------
1 recursive calls
0 db block gets
227990 consistent gets
227789 physical reads
0 redo size
426 bytes sent via SQL*Net to client
416 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
这么高的物理读正常么?有优化的空间吗?