SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script | Journey to SQL Authority with Pinal Dave

Index Rebuild : This process drops the existing Index and Recreates the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REBUILD GO Index Reorganize : This process physically reorganizes the leaf nodes of the index. USE AdventureWorks; GO ALTER INDEX ALL ON Production.Product REORGANIZE GO Recommendation: Index should be rebuild when index fragmentation is… Continue Reading...

Source: SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script | Journey to SQL Authority with Pinal Dave