Partilhar via


Implementing Indexes

The topics in this section provide the information to help you create, modify, drop, and view indexes on tables and views.

In This Section

Topic Description

Creating Indexes

Provides guidelines and examples specific to creating each Microsoft SQL Server 2005 index type.

Modifying Indexes

Provides guidelines and examples to modify, disable, or rename an index.

Determining Index Disk Space Requirements

Provides guidelines and examples to determine the disk space required to perform index DDL operations.

Dropping Indexes

Provides specific guidelines and examples to delete an index.

Viewing Index Information

Explains methods to find detailed information about existing indexes. This includes index properties and options.

See Also

Concepts

Designing Indexes
Indexes
Optimizing Indexes

Other Resources

Understanding Indexes

Help and Information

Getting SQL Server 2005 Assistance