Ordering: Open Query File (OPNQRYF) command performance

 

For ordering fields, the optimizer is not free to use any existing access path. The sort sequence tables associated with the index and the query must match unless the optimizer chooses to do a sort to satisfy the ordering request.

When a sort is used, the translation is performed during the sort, leaving the optimizer free to use any existing access path that meets the selection criteria.

 

Parent topic:

Open Query File (OPNQRYF) command: Performance considerations for sort sequence tables