Database | Indexes | Missing

As it generates execution plans, SQL Server records details of indexes that may improve query performance if they existed.

This report lists those indexes along with the CREATE INDEX statements that will create them. Remember that these are only suggestions and any additional indexes should be properly tested before implementing in a production environment.

What It ShowsComments
Object nameThe name of the table
Estimated impactA factor of the estimated cost saving per execution and the number of times the index would have been used
Last seekThe last time that this index may have been used
Creation scriptThe TSQL that should be used to create the index

This picture shows one of the missing indexes expanded to show the creation script.

< Database | Recommendations Database | Indexes | Unused >