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 level of fragmentation, Aireforge Studio may recommend either reorganizing the index or completely rebuilding it.

Suggested Action

đź’ˇ Select 'Suggested Script' for an automatically generated script.

  1. Defragment or rebuild the index.
  2. Implement an index maintenance strategy.

How to Defrag Indexes in SQL Server

DBCC INDEXDEFRAG (WhippetWorks, 'dbo.TableName', IX_IndexName);  
GO 

How to Rebuild Indexes in SQL Server

ALTER INDEX IX_IndexName ON TableName
REBUILD;

Further Reading

​DBCC INDEXDEFRAG | Microsoft Docs

​Reorganize and Rebuild Indexes | Microsoft Docs

​SQL Server Index and Statistics Maintenance | SQL Server Maintenance Solution