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

đź’ˇ Select 'Suggested Script' for an automatically generated script.

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.

Further Reading

​sys.dm_db_missing_index_details (Transact-SQL) | Microsoft Docs