Modifying Indexes
In Microsoft SQL Server 2005, you can perform common index maintenance tasks can by using the ALTER INDEX statement or Object Explorer in the SQL Server Management Studio. The topics in this section describe common tasks you can use to modify a clustered or nonclustered index on a table or view.
In This Section
| Topic | Description |
|---|---|
Describes temporarily removing user access to one or more indexes. |
|
Describes replacing the current index name with a new name. |
|
Describes defragmenting or rebuilding one or more indexes. |
|
Describes setting some index options without rebuilding the index. |
See Also
Concepts
Creating Indexes (Database Engine)
Designing Indexes
Optimizing Indexes