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.