Designing Indexes

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

Applies to: SQL Server 2008 R2 and higher versions.

In This Section

Topic	Description
Index Design Basics	Describes the major index design tasks.
General Index Design Guidelines	Contains 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.
Filtered Index Design Guidelines	Provides filtered index design guidelines and recommendations.