create index INX_DOCUMENTS#DEP_DOC_ID on DOC_PROP_DEPENDENCIES (DEPENDENT_DOCUMENT_ID)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );
create index NUNIDX_DOC#PROP on DOC_PROP_DEPENDENCIES (DEP_PROP_ID, DEPENDENT_DOCUMENT_ID)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );

----------------------
create index INX_DOCUMENTS#DEP_PROP_ID on DOC_PROP_DEPENDENCIES (DEP_PROP_ID)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );

create index INX_DOCUMENTS#DEP_DOCUMENT_ID on DOC_PROP_DEPENDENCIES (DOCUMENT_ID)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 16K
    minextents 1
    maxextents unlimited
  );


create index IND_DOC_REFS#TARG$SRC_ID on DOC_REFERENCES (DOCSOURCE_ID)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

create index IND_DOC_REFS#TARG$TRG_ID on DOC_REFERENCES (DOCTARGET_ID)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );