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