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.
💡 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
DROP INDEX (Transact-SQL) | Microsoft Docs