KnuGit/index.sql

CREATE INDEX CMCDBMGR.MOUMI_ACPT_LIMIT_STRATEGY_IDX99
  ON CMCDBMGR.MOUMI_ACPT_LIMIT_STRATEGY
    ( ID ASC, SUBMIT_LIMIT_CNT ASC, PRSS ASC )
  ALLOW REVERSE SCANS
  COMPRESS YES;

  
CREATE INDEX CMCDBMGR.MOUMI_BOARD_N49
  ON CMCDBMGR.MOUMI_BOARD
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;
  
  
CREATE INDEX CMCDBMGR.MOUMI_BOARD_N50
  ON CMCDBMGR.MOUMI_BOARD
    ( UPPER_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_BOARD_N51
  ON CMCDBMGR.MOUMI_BOARD
    ( GROUP_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_CATEGORY_N49
  ON CMCDBMGR.MOUMI_CATEGORY
    ( UPPER_CATEGORY_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE UNIQUE INDEX CMCDBMGR.MOUMI_DEPT_IDX99
  ON CMCDBMGR.MOUMI_DEPT
    ( ID ASC )
  INCLUDE ( NAME )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_MEMO_N49
  ON CMCDBMGR.MOUMI_MEMO
    ( REPORT_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_MEMO_N50
  ON CMCDBMGR.MOUMI_MEMO
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_REPOADM_N49
  ON CMCDBMGR.MOUMI_REPOADM
    ( REPORT_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE UNIQUE INDEX CMCDBMGR.MOUMI_SHARE_DOC_IDX01
  ON CMCDBMGR.MOUMI_SHARE_DOC
    ( DOC_ID ASC, USER_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_DOC_N49
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( REP_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_DOC_N50
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( ACPT_LIMIT ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_DOC_IDX01
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( END_DATE ASC, DEL_TYPE ASC, ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_DOC_N51
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( REP_DEPT_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_DOC_N52
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( DEPT_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE UNIQUE INDEX CMCDBMGR.MOUMI_TOT_DOC_IDX10
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( ID ASC )
  INCLUDE ( DEL_TYPE, END_DATE )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_DOC_IDX11
  ON CMCDBMGR.MOUMI_TOT_DOC
    ( OWNER_NAME ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_ITEM_N49
  ON CMCDBMGR.MOUMI_TOT_ITEM
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_LOG_N49
  ON CMCDBMGR.MOUMI_TOT_LOG
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_4TXY_N49
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( REP_DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_4TXY_N50
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DOWN_DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_4TXY_N51
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_4TXY_N52
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( CURRENT_REPOADM_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX01
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( USER_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX02
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DEPT_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX03
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DEPT_ID ASC, DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX12
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DOC_ID ASC, DEL_TYPE ASC, PRSS ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX11
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DEPT_ID ASC, USER_ID ASC, DOC_ID ASC, PRSS ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX98
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( DEPT_ID ASC, PRSS ASC, DEL_TYPE ASC )
  ALLOW REVERSE SCANS
  COMPRESS YES;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_IDX99
  ON CMCDBMGR.MOUMI_TOT_REPORT
    ( USER_ID ASC, PRSS ASC, DEL_TYPE ASC )
  ALLOW REVERSE SCANS
  COMPRESS YES;


CREATE INDEX CMCDBMGR.MOUMI_TOT_E4RJ_N49
  ON CMCDBMGR.MOUMI_TOT_REPORT_HISTORY
    ( TOT_REPORT_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_TOT_REPORT_VERSION_IDX01
  ON CMCDBMGR.MOUMI_TOT_REPORT_VERSION
    ( REPORT_ID DESC, PRSS ASC )
  ALLOW REVERSE SCANS
  COMPRESS YES;


CREATE INDEX CMCDBMGR.MOUMI_TOT_O2PK_N49
  ON CMCDBMGR.MOUMI_TOT_TABLE
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_USERUFGP_N49
  ON CMCDBMGR.MOUMI_USER_DEPT
    ( PART_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_USERE6XC_N49
  ON CMCDBMGR.MOUMI_USER_HISTORY
    ( DOC_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_USER_PART_IDX01
  ON CMCDBMGR.MOUMI_USER_PART
    ( USER_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;


CREATE INDEX CMCDBMGR.MOUMI_USER5KCV_N49
  ON CMCDBMGR.MOUMI_USER_USER
    ( PART_ID ASC )
  ALLOW REVERSE SCANS
  COMPRESS NO;