ALTER INDEX

SQL Server Index Fragmentation: When to Rebuild or Reorganize an Index

Measure index fragmentation and page density in SQL Server, then choose ALTER INDEX REORGANIZE, REBUILD or a statistics update, with online and resumable options.