建立分区表:
create table ta
(
c1 int,
c2 varchar2(16),
c3 varchar2(64),
c4 int,
constraint pk_ta primary key (c1)
)
partition by range(c4)
(
partition p1 values less than (10000000),
partition p2 values less than (20000000),
partition p3 values less than (maxvalue)
); 建立分区索引:
create index idx_ta_c2 on ta(c2)
local (
partition p1,
partition p2,
partition p3
); 问题:
1、建立了分区表后是不是一定要建分区索引?
2、为什么表上是按c4分区,索引却按c2分区?但是索引分区的个数必须跟表分区个数相等
create table ta
(
c1 int,
c2 varchar2(16),
c3 varchar2(64),
c4 int,
constraint pk_ta primary key (c1)
)
partition by range(c4)
(
partition p1 values less than (10000000),
partition p2 values less than (20000000),
partition p3 values less than (maxvalue)
); 建立分区索引:
create index idx_ta_c2 on ta(c2)
local (
partition p1,
partition p2,
partition p3
); 问题:
1、建立了分区表后是不是一定要建分区索引?
2、为什么表上是按c4分区,索引却按c2分区?但是索引分区的个数必须跟表分区个数相等
--这是网上看到解释非前缀分区索引跟前缀分区索引的,跟我说的问题不一样啊