...

--drop        index IX_ADDR4FRM;
create        index IX_ADDR4FRM on ADDRESS(
 LOCATION_TYPE,
 LOCATION_NAME,
 SOURCE,
 STATE_ID,
 COUNTY,
 CITY,
 STREET)
  tablespace VCIN_ADDR_INDX
   storage (initial 32M next 4M pctincrease 0 maxextents 200);

--drop        index IX_ADDRESS_FCN;
create        index IX_ADDRESS_FCN on ADDRESS(
 FCN)
  tablespace VCIN_ADDR_INDX
   storage (initial 16M next 4M pctincrease 0 maxextents 200);

--drop        index IX_ADDRESS_HIST_FCN;
create        index IX_ADDRESS_HIST_FCN on ADDRESS_HIST(
 FCN)
  tablespace VCIN_ADDR_INDX
   storage (initial 16M next 4M pctincrease 0 maxextents 200);

--drop        index PK_ADDRESS;
create UNIQUE index PK_ADDRESS on ADDRESS(
 ADDR_ID)
  tablespace VCIN_ADDR_INDX
   storage (initial 8M next 4M pctincrease 0 maxextents 200);

--drop        index PK_ADDRESS_HIST;
create UNIQUE index PK_ADDRESS_HIST on ADDRESS_HIST(
 ADDRESS_GEN_NBR)
  tablespace VCIN_ADDR_INDX
   storage (initial 12M next 4M pctincrease 0 maxextents 200);

--drop        index UN_ERROR_ID;
create UNIQUE index UN_ERROR_ID on VCIN_ERROR(
 ERROR_ID)
  tablespace VCIN_COMM_INDX
   storage (initial 64K next 64K pctincrease 0 maxextents 200);

...