Question: what are the primary differences between an index reorganization and an index rebuild?
Answer: Index Reorganize : This process physically reorganizes the leaf nodes of the index. Recommendation: Index should be rebuild when index fragmentation is great than 40%. Index should be reorganized when index fragmentation is between 10% to 40%. Index rebuilding process uses more CPU and it locks the database resources.