Changes to the data model for Db2®

Indexes

To change the existing OBJ_SOI_IDX index, a new index is created and the existing one is then dropped.

The following index was added:
  • OBJ_USOI_IDX on the OBJ_BASE table. The index is UNIQUE and EVENT_ID is now an include column.
The following index was dropped:
  • OBJ_SOI_IDX on the OBJ_BASE table.
The following index was added:
  • OBJ_AUD_IDX on H_OBJ_BASE table. The index columns are ID, STATUS_DATE and AUDIT_SEQ.
The following index was dropped:
  • HIS_OBJ_IDX on the H_OBJ_BASE table.