DROP INDEX VETCHOICE.TPA_LOAD_DATE_IDX;

CREATE INDEX VETCHOICE.TPA_LOAD_DATE_IDX ON VETCHOICE.AGGREGATE_H
(TPA_LOAD_DATE)
LOGGING
TABLESPACE L_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            MAXSIZE          UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX VETCHOICE.SSN_IDX;

CREATE INDEX VETCHOICE.SSN_IDX ON VETCHOICE.AGGREGATE_H
(SSN)
LOGGING
TABLESPACE L_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            MAXSIZE          UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX VETCHOICE.PERID_IDX;

CREATE INDEX VETCHOICE.PERID_IDX ON VETCHOICE.AGGREGATE_H
(PERID)
LOGGING
TABLESPACE L_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            MAXSIZE          UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
DROP INDEX VETCHOICE.EDIPI_IDX;

CREATE INDEX VETCHOICE.EDIPI_IDX ON VETCHOICE.AGGREGATE_H
(EDIPI)
LOGGING
TABLESPACE L_INDEX_01
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            MAXSIZE          UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
            FLASH_CACHE      DEFAULT
            CELL_FLASH_CACHE DEFAULT
           )
NOPARALLEL;
