Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2008
Database Engine
Operations
Performance
Query Performance
Query Tuning
Community Content
In this section
Statistics Annotations (0)
Collapse All/Expand All Collapse All
Other versions are also available for the following:
SQL Server 2008 Books Online (November 2009)
Finding Missing Indexes

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.

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 of 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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2010 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker