3同行回答
哦，
CREATE INDEX anbob.idx2
ON anbob.t (id)
GLOBAL
partition by range(id)
(partition manager_100 values less than (1000000),
partition manager_200 values less than (2000000),
partition manager_300 values less than (3000000),
partition manager_400 values less than (4000000),
partition manager_max values less than (maxvalue));
create index anbob.idx1 on anbob.t(name) local;
CREATE INDEX anbob.idx2
ON anbob.t (id)
GLOBAL
partition by range(id)
(partition manager_100 values less than (1000000),
partition manager_200 values less than (2000000),
partition manager_300 values less than (3000000),
partition manager_400 values less than (4000000),
partition manager_max values less than (maxvalue));
create index anbob.idx1 on anbob.t(name) local;
select index_name, locality from dba_part_indexes where index_name in('IDX1','IDX2');
INDEX_NAME LOCALI
------------------------------ ------
IDX1 LOCAL
IDX2 GLOBAL收起你那个ＰＤＦ里没有提到如果判断一个索引是本地分区索引还是全局索引啊！收起
浏览3436
有种经验值的说法， oltp 尽量global partition index, 但是出于表上后期的维护性，和业务的不间断性，和主键和查询语句都有关联性
这个问题在资料里面有提到：http://www.db2china.net/club/thread-65671-1-1.html”。收起
这个问题在资料里面有提到：http://www.db2china.net/club/thread-65671-1-1.html”。收起
浏览3494