Index Fragmentation Exceeds Acceptable Limit
This warning has been raised because the index is fragmented more than the percentage limit set in the Aireforge Studio settings. Highly fragmented indexes are less efficient and can use more storage (disk and memory) than less fragmented ones.
Depending on the fragmentation level and the edition of SQL Server, Aireforge Studio may recommend either reorganizing the index or completely rebuilding it.
💡 Aireforge Advisor can automatically generate a script for this.
- Defragment or rebuild the index.
- Implement an index maintenance strategy.
How to Defrag Indexes in SQL Server
DBCC INDEXDEFRAG(WhippetWorks, 'dbo.TableName', IX_IndexName);
How to Rebuild Indexes in SQL Server
ALTER INDEX IX_IndexName ON TableName
REBUILD WITH (ONLINE = ON, SORT_IN_TEMPDB = ON);
DBCC INDEXDEFRAG | Microsoft Docs
Reorganize and Rebuild Indexes | Microsoft Docs
SQL Server Index and Statistics Maintenance | SQL Server Maintenance Solution