Index example: Equal selection with a shared-weight sort sequence table

 

Equal selection with a shared-weight sort sequence table (SRTSEQ(*LANGIDSHR) LANGID(ENU)).

  SELECT * FROM STAFF    WHERE JOB = 'MGR'

When using the OPNQRYF command, specify:

OPNQRYF FILE((STAFF)) 
   QRYSLT('JOB *EQ ''MGR''')
   SRTSEQ(*LANGIDSHR) LANGID(ENU)

The system can only use index SHRIX.

 

Parent topic:

Examples of indexes