DB2® uses indexes
for a variety of reasons. DB2 indexes
enforce uniqueness on column values, as in the case of parent keys. DB2 indexes are also used to cluster
data, to partition tables, to provide access paths to data, and to
order retrieved data without a sort.