Sort access

Db2 can use two general types of sorts that Db2 can use when accessing data. One is a sort of data rows; the other is a sort of row identifiers (RIDs) in a RID list. You can use Db2 EXPLAIN to determine whether a SQL statement requires sort operations.