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