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
Cheers,
Venkatesan Prabu .J
Head, KaaShiv InfoTech
For free Ebook : http://kaashivinfotech.com/Ebooks.aspx
I like your page! So what are the benefits of rebuild and reorganize?
ReplyDelete