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