Suggested Index

SQL Server builds up statistics on queries that don't use an index, generating suggested indexes. Aireforge Studio uses these suggestions to generate more specific suggested indexes, that may or may not supersede existing ones.

Suggested Action

Consider implementing the index, taking into account the columns, other indexes (missing and active), missing index impact, and the read:write ratio of the table.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.