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 Shows||Comments|
|Object name||The name of the table|
|Estimated impact||A factor of the estimated cost saving per execution and the number of times the index would have been used|
|Last seek||The last time that this index may have been used|
|Creation script||The 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 >