2008-09-18 15:26:52 / Oracle数据库管理
有一个表数据比较大，于是重建了一个分区表，并将数据转移过去，完成后用同样的SQL去测试，缺发现效率大大降低这个是没有分区的表select sum(th_total_redeem) from txn_header_his_old where th_lms_posting_date between '20080301' and '20080331' and th_corporate_no='086755541100328';Elapsed: 00:00:45.87Execution Plan----------------------------------------------------------0SELECT STATEMENT Optimizer=CHOOSE10SORT (AGGREGATE)21TABLE ACCESS (BY INDEX ROWI
查看(453)
评论(27)
