Reorganise index vs Rebuild Index in Sql Server Maintenance plan
The reorganize and rebuild are different things. Reorganize: it’s a defrag for indexes. Takes the existing index(es) and defragments the existing pages. However if the pages are not in a contiguous manner, they stays like before. Only the content of the pages are changing. Rebuild: actually it drops the index and rebuilds it from scratch. … Read more