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.