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.
💡 Select 'Suggested Script' for an automatically generated script.
- Defragment or rebuild the index.
- 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 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