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.
💡 Select 'Suggested Script' for an automatically generated script.
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
Rename Indexes | Microsoft Docs