This topic has not yet been rated - Rate this topic

Designing Indexes

SQL Server 2008 R2

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.

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions