Unused Index Detected
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.
💡 Select 'Suggested Script' for an automatically generated script.
Consider dropping the unused index.
How to Drop an Unused Index
DROP INDEX [IX_IndexName] ON [TableName] GO
DROP INDEX (Transact-SQL) | Microsoft Docs
sys.dm_db_index_usage_stats (Transact-SQL) | Microsoft Docs