When an index is rebuilt, it is dropped and a new one is created.
In the process fragmentation is removed and disk space is reclaimed.
ALTER INDEX PK_CustId ON Sales.Customer REBUILD
REORGANIZE THE INDEX
Minor Level modification, so that rearranging of the tree node is done.
Small Fragmentation is removed, the index
remains.
ALTER INDEX PK_CustId ON Sales.Customer REORGANIZE
Join the conversation! Your thoughts help the community grow.