huawei--创建索引,用到表空间

来源:互联网 发布:mba 知乎 编辑:程序博客网 时间:2024/05/16 04:45

DROP INDEX indBillLog1_CallEnd
CREATE INDEX indBillLog1_CallEnd
ON tBillLog1 (CallEnd)
  TABLESPACE ICD_BILLLOG_IND LOCAL 
  PCTFREE 10
  INITRANS 2
  MAXTRANS 255
  STORAGE (
  INITIAL 128k
  NEXT 128k
  MINEXTENTS 1
  MAXEXTENTS 500
  PCTINCREASE 0
  FREELISTS 1
  FREELIST GROUPS 1
  )
/
CREATE INDEX indBookOutbound
ON tBookOutbound(AckTime,SubCCNO,VDN,MediaType)
TABLESPACE ICD_SERVICE_IND
/
CREATE INDEX ix_DayLogTmp_CallByTrk ON t_DayLogTmp_CallByTrk (CallID)
  TABLESPACE ICD_SERVICE_IND
  PCTFREE 10
  INITRANS 2
  MAXTRANS 255
  STORAGE (
  INITIAL 128k
  NEXT 128k
  MINEXTENTS 1
  MAXEXTENTS 500
  PCTINCREASE 0
  FREELISTS 1
  FREELIST GROUPS 1
  );