15.5.12

REBUILDING VS REORGANIZE THE INDEX


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 

1 comment:

  1. I like your page! So what are the benefits of rebuild and reorganize?

    ReplyDelete