Duplicate or Overlapping Index

This warning has been raised because this index is a duplicate of another one, indexing on exactly the same columns in the same order.

  • If the duplicate has one or more included columns that the other does, then Aireforge Studio will suggest merging the indexes (i.e., creating one index with the union of all the included columns from both).
  • If the duplicate doesn't have any extra included columns, then it is suggested that you drop the additional index.

Suggested Action

šŸ’” Aireforge Advisor can automatically generate a script for this.

Drop identical indexes and consider merging overlapping indexes.

How to Drop an Index in SQL Server

DROP INDEX IX_Name ON TableName;
GO  

Further Reading

DROP INDEX (Transact-SQL) | Microsoft Docs