Indexes
An index is a persisted ordering of records in a table. Indexes are used for both sequential access to rows in the order defined, and for direct record navigation based on indexed column values. The order defined by an index is described in terms of an array of columns, in precedence order. This array of columns is also called the index key. Each column is called an index segment. Each index segment may be either ascending or descending, in terms of its ordering contribution. Any number of indexes may be defined for a table. ESE provides a rich set of indexing features.
Read more about this topic: Extensible Storage Engine
Famous quotes containing the word indexes:
“Our memories are card indexes consulted and then returned in disorder by authorities whom we do not control.”
—Cyril Connolly (1903–1974)