Index Name Violates Index Naming Convention

Although the name of an index has no impact on performance, poorly named indexes can have an impact on support and maintenance, leading to unnecessary duplication and poorly optimized indexes. As such, any indexes detected as not matching your index naming strategy (as configured in Aireforge Studio) will be flagged up with this warning.

⚠ This warning is based on the correct input of your index naming convention in Aireforge Studio, so if you see lots of indexes flagged with this warning, that you believe aren't wrongly named, check the setting first.

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Update the index name to match the naming convention defined in Aireforge Studio.

How to Rename an Index in SQL Server

EXEC sp_rename N'dbo.TableName.IX_IndexName',
               N'IX_NewIndexName',
               N'INDEX';
GO

Further Reading

Rename Indexes | Microsoft Docs