Working with Indexes

An index is a mechanism for providing fast access to table rows or for enforcing certain constraints. For an overview of indexes, see Indexes.

For details about working with indexes, see the following topics:

To	See
Create an index	Creating an Index
Create an indexed view	Creating Indexed Views
Create a unique index	Creating a Unique Index
Create a clustered index	Creating a Clustered Index
Rename an index	Renaming an Index
Delete an index	Deleting an Index
Save, display, and update an index definition	Saving, Displaying, and Updating an Index Definition
Specify a fill factor for an index	Specifying a Fill Factor for an Index