Working with Indexes

An index is a mechanism for providing fast access to table rows or for enforcing certain constraints.

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

In This Section

How to: Create Indexes

How to: Create Unique Indexes

How to: Create Clustered Indexes

How to: Create Full-Text Indexes

How to: Create Spatial Indexes

How to: Create XML Indexes

How to: Change Index Properties

How to: Rename Indexes

How to: Delete Indexes

How to: Delete Full-Text Indexes from Databases

How to: Delete Spatial Indexes

How to: Delete XML Indexes

How to: Sort Data in a Clustered Index

How to: Specify Fill Factors for Indexes

How to: Show Index Properties