Export (0) Print
Expand All
2 out of 3 rated this helpful - Rate this topic

Indexes

Like an index in a book, an index in a database lets you quickly find specific information in a table or indexed view. An index contains keys built from one or more columns in the table, or view, and pointers that map to the storage location of the specified data. You can significantly improve the performance of database queries and applications by creating well-designed indexes to support your queries. Indexes can reduce the amount of data that must be read to return the query result set. Indexes can also enforce uniqueness on the rows in a table, ensuring the data integrity of the table data.

The topics in this section provide the information to help you understand, design, implement, and optimize indexes.

Topic Description

Understanding Indexes

Explains index concepts and includes descriptions of each index type available in SQL Server 2005.

Designing Indexes

Provides guidelines, rules, and restrictions you should know when you design an index.

Implementing Indexes

Provides guidelines, rules, and restrictions you should know when you create, modifying, or dropping an index.

Optimizing Indexes

Provides specific guidelines and tips for maintaining index performance and maximizing index operations.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.