Working with Indexes |
|
An index is used to facilitate random access of table rows; it is a sub-table of the table containing the accessing rows. The index table contains the key columns of its parent table. Indexes are particularly useful for tables that hold large amounts of data, or tables that are frequently accessed. An index can be unique or non-unique. In a unique index, no more than one row can have the same key value, with the exception that any number of rows may have NULL values.
Related topic:
Working
with Signature Text Indexes
Creating an Index
Dropping an Index
Rebuilding an Index
Updating Index Statistics