Using indexes and sort sequence with ordering

 

Unless the optimizer chooses to do a sort to satisfy the ordering request, the sort sequence table associated with the index must match the sort sequence table associated with the query.

When a sort is used, the translation is done during the sort. Since the sort is handling the sort sequence requirement, this allows DB2 Universal Database™ for iSeries™ to use any existing index that meets the selection criteria.

 

Parent topic:

Using indexes with sort sequence