重組並重建索引
avg_fragmentation_in_percent 值 | 糾正宣告 |
---|---|
> 5%且<= 30% | 改組 |
> 30%的 | 重建 |
ALTER INDEX IX_NonClustered ON tableName REORGANIZE;
ALTER INDEX ALL ON Production.Product
REBUILD WITH (FILLFACTOR = 80, SORT_IN_TEMPDB = ON,
STATISTICS_NORECOMPUTE = ON);