Unused Index

This warning has been raised because SQL Server's statistics indicate that this index has never been used.

⚠ This warning is purely based on SQL Server's statistics, which are only populated by querying of the database. If the database has just been restarted or restored, or it's a replica database that is never used for selects, then the statistics will not accurately represent whether the index is used or not.

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Consider dropping the unused index.

How to Drop an Unused Index

DROP INDEX [IX_IndexName] ON [TableName]
GO

Further Reading

​DROP INDEX (Transact-SQL) | Microsoft Docs

sys.dm_db_index_usage_stats (Transact-SQL) | Microsoft Docs