Finding Missing Indexes

Article
12/03/2008

New: 5 December 2005

The missing indexes feature is a lightweight, always-on way to identify indexes missing on database tables and indexed views that might enhance query performance if implemented.

In This Section

Topic	Description
About the Missing Indexes Feature	Describes the components of the missing indexes feature and how to enable or disable this feature.
Using Missing Index Information to Write CREATE INDEX Statements	Provides guidelines for and examples of using the information returned by the missing index feature components to write CREATE INDEX DDL statements.
Limitations for Using the Missing Indexes Feature	Describes limitations and restrictions for using the missing indexes feature.
Related Query Tuning Features	Lists other SQL Server features that can be used with the missing indexes feature to tune query performance.