全部博文
-
编辑 删除
Oracle10g Database Table Partition Testcase-5 严于律己
8.比较全局普通索引和本地非前缀索引性能： CREATE INDEX IDX_HK_P_MER_CODE ON TIPS_TRD_HK_P(MER_CODE) LOCAL; select * from ips2.TIPS_TRD_HK_P where MER_CODE='010870' Plan SELECT STATEMENT ALL_ROWS Cost: 16 Bytes: 17,202 Cardinality: 6 3 PARTITION RANGE ALL Cost: 16 Bytes: 17,202 Cardinality: 6 Partition #: 1 Partitions accessed #1 - #7
