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 |