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 for additional guidance on proper index creation, usage and maintenance.