Creating the DB2 indexes

DB2® performance improves with the use of indexes. Member RACDBUTB in SYS1.SAMPLIB creates an index for every primary key and every foreign key identified in the record types. Figure 1 contains sample statements to create the indexes for the Group Basic Data record.

Figure 1. Sample SQL utility statements: Creating indexes

CREATE UNIQUE INDEX userid.GROUP_BD_IX1
       ON userid.GROUP_BD
          (GPBD_NAME)
          USING   STOGROUP storagegroup
          PRIQTY  100
          SECQTY  50
          CLUSTER
          PCTFREE 0
          CLOSE   NO
          ;
CREATE UNIQUE INDEX userid.GROUP_BD_IX2
       ON userid.GROUP_BD
          (GPBD_NAME, GPBD_SUPGRP_ID)
          USING   STOGROUP storagegroup
          PRIQTY  100
          SECQTY  50
          PCTFREE 0
          CLOSE   NO
          ;
CREATE INDEX userid.GROUP_BD_IX3
       ON userid.GROUP_BD
          (GPBD_OWNER_ID)
          USING   STOGROUP storagegroup
          PRIQTY  100
          SECQTY  50
          PCTFREE 0
          CLOSE   NO
          ;
CREATE INDEX userid.GROUP_BD_IX4
       ON userid.GROUP_BD
          (GPBD_MODEL)
          USING   STOGROUP storagegroup
          PRIQTY  100
          SECQTY  50
          PCTFREE 0
          CLOSE   NO
          ;