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

Consider dropping the unused index.

How to Drop an Unused Index

DROP INDEX [IX_IndexName] ON [TableName]

Further Reading

​DROP INDEX (Transact-SQL) | Microsoft Docs

sys.dm_db_index_usage_stats (Transact-SQL) | Microsoft Docs