This topic has not yet been rated - Rate this topic

Modifying Indexes

SQL Server 2008

SQL Server 2008 R2
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
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.

Concepts

Creating Indexes (Database Engine)

Designing Indexes

Optimizing Indexes

Other Resources

Understanding Indexes

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD