Understanding Indexes

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

In This Section

• 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 and provides references to additional information.

See Also

Concepts

Designing Indexes

Implementing Indexes

Indexes

Optimizing Indexes