Finding Missing Indexes
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 |
|---|---|
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. |
Describes limitations and restrictions for using the missing indexes feature. |
|
Lists other SQL Server features that can be used with the missing indexes feature to tune query performance. |