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.