Using indexes with sort sequence

 

The following sections provide useful information about how indexes work with sort sequence tables.

• Using indexes and sort sequence with selection, joins, or grouping
  Before using an existing index, DB2 Universal Database for iSeries ensures the attributes of the columns (selection, join, or grouping columns) match the attributes of the key columns in the existing index. The sort sequence table is an additional attribute that must be compared.

• 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.

 

Parent topic:

Creating an index strategy