Use ALTER INDEX REORGANIZE, the replacement for DBCC INDEXDEFRAG, to reorder the leaf level pages of the index in a logical order.

• 使用ALTER INDEX REORGANIZE(代替DBCC INDEXDEFRAG)按逻辑顺序重新排序索引的叶级页。