Understanding Indexes

  • Article

The topics in this section provide the information to help you understand indexes and the index types that are available in Microsoft SQL Server 2005.

In This Section

Topic Description

Index Basics

Explains basic index concepts and how the query optimizer uses indexes to retrieve data.

Types of Indexes

Lists the types of indexes available in SQL Server 2005 and provides references to additional information.

See Also

Concepts

Designing Indexes
Implementing Indexes
Indexes
Optimizing Indexes

Help and Information

Getting SQL Server 2005 Assistance