Oracle分区,索引,测试(2)(三)
Predicate Information (identified by operation id):
---------------------------------------------------
7 - access("SALES_DATA"."CITY_ID"="CITY"."CITY_ID")
18 - access("SALES_DATA"."SALES_DATE"=TO_DATE('2009-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') OR "SALES_DATA"."SALES_DATE"=TO_DATE('2009-03-05 00:00:00',
'yyyy-mm-dd hh24:mi:ss'))
Statistics
-----------------------------------------------------------
76 recursive calls
0 consistent gets direct
3644 physical reads direct
0 recovery blocks read
0 redo buffer allocation retries
用了50秒.. 看来还是要用oralce 自己的优化器... 用了比没用 多了一半的时间