Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Topic Description

Disabling Indexes

Describes temporarily removing user access to one or more indexes.

Renaming Indexes

Describes replacing the current index name with a new name.

Reorganizing and Rebuilding Indexes

Describes defragmenting or rebuilding one or more indexes.

Setting Index Options

Describes setting some index options without rebuilding the index.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft