Index examples

The following index examples are provided to help you create effective indexes.

For the purposes of the examples, assume that three indexes are created.

Assume that an index HEXIX was created with *HEX as the sort sequence.

   CREATE INDEX HEXIX ON STAFF (JOB)

Assume that an index UNQIX was created with a unique-weight sort sequence.

   CREATE INDEX UNQIX ON STAFF (JOB)

Assume that an index SHRIX was created with a shared-weight sort sequence.

   CREATE INDEX SHRIX ON STAFF (JOB)