Index Guidelines

An index is a balanced B-tree structure that orders the values of columns in a table. When you index a table by one or more of its columns, you can access data directly and more efficiently because the index is ordered by the columns to be retrieved. Consult Chapter 6, "DB2 Indexes," for additional guidance on proper index creation, usage, and maintenance.