Index example: Equals selection with no sort sequence table

 

Equals selection with no sort sequence table (SRTSEQ(*HEX)).

  SELECT * FROM STAFF     WHERE JOB = 'MGR'

When using the OPNQRYF command, specify:

OPNQRYF FILE((STAFF)) 
   QRYSLT('JOB *EQ ''MGR''')
   SRTSEQ(*HEX)

The system can use either index HEXIX or index UNQIX.

 

Parent topic:

Examples of indexes