建立索引,对表tab的字段id建立索引 CREATE INDEX index_tab ON tab(id)
见表的语句供参考,请问如何再给索引组织表加索引? 只能加一个辅助索引吗?好像性能一般creat table userinfo ( UID VARCHAR2(16) NOT NULL, Password VARCHAR2(32), levelID NUMBER(38, 0) NOT NULL, MailRoot NUMBER(38, 0) DEFAULT 0 NOT NULL, NDRoot NUMBER(38, 0), Disabled NUMBER(38, 0), DisabledSource NUMBER(38, 0), DisabledOperator VARCHAR2(16), DisabledTime DATE, CreateSource NUMBER(38, 0), CreateOperator VARCHAR2(16), CreateTime DATE, LastUpdateTime DATE, Forward VARCHAR2(100), CONSTRAINT PK1 PRIMARY KEY (UID) ) ORGANIZATION INDEX INCLUDING uid OVERFLOW tablespace AIMCPRO_INDEX partition by hash(uid) (partition userinfo_part_01 tablespace AIMCPRO_DATA_01 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_02 tablespace AIMCPRO_DATA_02 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_03 tablespace AIMCPRO_DATA_03 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_04 tablespace AIMCPRO_DATA_04 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_05 tablespace AIMCPRO_DATA_05 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_06 tablespace AIMCPRO_DATA_06 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_07 tablespace AIMCPRO_DATA_07 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8, partition userinfo_part_08 tablespace AIMCPRO_DATA_08 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8 )
(oracle9i) 索引组织表的 辅助索引 是 二次索引 吗
急-----------请问索引组织表里的“OVERFLOW“ 表空间可以定义多个吗? PCTTHRESHOLD 20 INCLUDING re OVERFLOW TABLESPACE users;一般PCTTHRESHOLD 和 INCLUDING 如何设置, OVERFLOW TABLESPACE 可以设置为多个吗?
CREATE INDEX index_tab ON tab(id)
只能加一个辅助索引吗?好像性能一般creat table userinfo
(
UID VARCHAR2(16) NOT NULL,
Password VARCHAR2(32),
levelID NUMBER(38, 0) NOT NULL,
MailRoot NUMBER(38, 0) DEFAULT 0 NOT NULL,
NDRoot NUMBER(38, 0),
Disabled NUMBER(38, 0),
DisabledSource NUMBER(38, 0),
DisabledOperator VARCHAR2(16),
DisabledTime DATE,
CreateSource NUMBER(38, 0),
CreateOperator VARCHAR2(16),
CreateTime DATE,
LastUpdateTime DATE,
Forward VARCHAR2(100),
CONSTRAINT PK1 PRIMARY KEY (UID)
)
ORGANIZATION INDEX INCLUDING uid OVERFLOW tablespace AIMCPRO_INDEX
partition by hash(uid)
(partition userinfo_part_01 tablespace AIMCPRO_DATA_01 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_02 tablespace AIMCPRO_DATA_02 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_03 tablespace AIMCPRO_DATA_03 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_04 tablespace AIMCPRO_DATA_04 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_05 tablespace AIMCPRO_DATA_05 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_06 tablespace AIMCPRO_DATA_06 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_07 tablespace AIMCPRO_DATA_07 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8,
partition userinfo_part_08 tablespace AIMCPRO_DATA_08 storage (initial 100m next 100m pctincrease 0) nologging PARALLEL 8
)
PCTTHRESHOLD 20
INCLUDING re
OVERFLOW TABLESPACE users;一般PCTTHRESHOLD 和 INCLUDING 如何设置,
OVERFLOW TABLESPACE 可以设置为多个吗?