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

💡 Aireforge Advisor can automatically generate a script for this.

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