What are number-of-subpartitions of composite range-hash partitioning tables (number of subpartitions在组合分区表中的作用)？ 10g官档中：http://docs.oracle.com/cd/B19306_01/server.102/b14231/partiti.htm#sthref260

Partitioning table 初识，区分（堆表与分区表、分区特性） 1、create range partition table CREATE TABLE time_range_sales  ( prod_id        NUMBER(6)  , cust_id        NUMBER  , time_id       DATE

partitioned indexes         local partitioned index                   CREATE INDEX hash_sales_idx ON hash_sales(time_id) LOCAL;                   advantages                            avai

分区索引维护（addpartition） 总结：    1．分区表添加新的分区：        Global index: 全局索引会被标识为“不可用”        Local index:本地索引会自动维护未被修改的分区，修改的分区可能会导致索引不可用，所以使用本地索引，添加新分区后也要检测一下索引的有效性（user_ind_partitions）    2．分区表添加

Partition管理问题集锦  ORA-14086: a partitioned index may not berebuilt as a whole(rebuild index)ORA-14074: partition boundmust collate higher than that of the last partition(add partition)  O

分区表与堆表执行计划的不同 Execution Plan----------------------------------------------------------Plan hash value: 84294021 ----------------------------------------------------------------------------

高效的partition（使用分区条件） Partition技术中：高效的SQL应尽量使用分区条件 range分区表create table range_tab(id int,col2 int,col3int)partition by range(id)(partition p1 values less than (1000),partition p2 va