索引的初始
CREATE INDEX "DATACORE"."ZZB_1104_INDEX" ON "DATACORE"."ZZB_1104"
(
"DATA_DATE",
"KMDH",
"JGDH",
"HB"
)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE
(
INITIAL 3145728 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT
)
TABLESPACE "DATACORE" ;
对于30w的数据 初始拓展(INITIAL)和下次拓展 (NEXT ) 这个值应该设置多少比较合适?