drop index DOC_EVENTS_POST
/
create index DOC_EVENTS_POST on DOC_EVENTS (EVENT_USER, DOCEVENTKIND_ID, EVENT_DATE, HISTORY)
  tablespace INDX
  pctfree 10
  initrans 5
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  )
/
drop index IND_DOC_EVN#DOC$HI$KND$EVNKND
/
create index IND_DOC_EVN#DOC$HI$KND$EVNKND on DOC_EVENTS (DOCUMENT_ID, HISTORY, DOCKIND_ID, DOCEVENTKIND_ID)
  tablespace INDX
  pctfree 10
  initrans 5
  maxtrans 255
  storage
  (
    initial 256K
    minextents 1
    maxextents unlimited
  )
/
drop index IND_D_EVN#DCEVK$HI$DC_ID
/
create index IND_D_EVN#DCEVK$HI$DC_ID on DOC_EVENTS (DOCEVENTKIND_ID, HISTORY, DOCUMENT_ID)
  tablespace INDX
  pctfree 10
  initrans 5
  maxtrans 255
  storage
  (
    initial 256K
    minextents 1
    maxextents unlimited
  )
/
drop index IND_D_EVN#DCKND_ID$HI$DC_ID
/
create index IND_D_EVN#DCKND_ID$HI$DC_ID on DOC_EVENTS (DOCKIND_ID, HISTORY, DOCUMENT_ID)
  tablespace INDX
  pctfree 10
  initrans 5
  maxtrans 255
  storage
  (
    initial 256K
    minextents 1
    maxextents unlimited
  )
/
drop index IND_D_EVN#DKND$DEVKND$HI
/
create index IND_D_EVN#DKND$DEVKND$HI on DOC_EVENTS (DOCKIND_ID, DOCEVENTKIND_ID, HISTORY)
  tablespace INDX
  pctfree 10
  initrans 5
  maxtrans 255
  storage
  (
    initial 2M
    minextents 1
    maxextents unlimited
  )
/
drop index XIF232DOC_EVENTS
/
create index XIF232DOC_EVENTS on DOC_EVENTS (DOCFOLDER_ID)
  tablespace INDX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  )
/
drop index XIF236DOC_EVENTS
/
create index XIF236DOC_EVENTS on DOC_EVENTS (PREVIOUS_EVENT)
  tablespace INDX
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 256K
    minextents 1
    maxextents unlimited
  )
/
