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.