Designing Indexes

The topics in this section provide the information that will help you design efficient and effective indexes.

In This Section

Topic Description

Index Design Basics

Describes the major index design tasks.

General Index Design Guidelines

Provides additional guidelines related to index design tasks. Guidelines are categorized by database, query, and column considerations.

Clustered Index Design Guidelines

Provides clustered index design guidelines and recommendations.

Nonclustered Index Design Guidelines

Provides nonclustered index design guidelines and recommendations.

Unique Index Design Guidelines

Provides unique index design guidelines and recommendations.

See Also

Concepts

Implementing Indexes
Indexes
Optimizing Indexes

Other Resources

Understanding Indexes

Help and Information

Getting SQL Server 2005 Assistance