Reorganizing and rebuilding

Reorganizing an index fixes the arrangement of pages, and compress pages to apply any previously set fill factor settings. The recommended index fragmentation for reorganize is more than 5% and less than or equal to 30%.

Rebuilding an index drops and re-creates the index. The recommended index fragmentation for rebuild is above 30%.