全部博文
-
编辑 删除
Oracle10g Database Table Partition Testcase-3 严于律己
5.创建全局索引： SELECT * FROM IPS2.TIPS_TRD_HK_P WHERE HB_SDATE>SYSDATE-10 Plan SELECT STATEMENT ALL_ROWS Cost: 11,890 Bytes: 1,909,422 Cardinality: 666 2 PARTITION RANGE ALL Cost: 11,890 Bytes: 1,909,422 Cardinality: 666 Partition #: 1 Partitions accessed #1 - #8 1 TABLE ACCESS FULL TABLE IPS2.TIPS_TRD_HK_P Cost: 11,890 Bytes: 1,909,422 Cardinality: 666 Partition #: 1
