The below are the key differences between Index Rebuild and Reorganize .
| S.No |
Index Rebuild |
Index
Reorganize |
| 1 |
Index
Rebuild drops the existing Index and Recreates the index from scratch. |
Index
Reorganize physically reorganizes the leaf nodes of the index. |
| 2 |
Rebuild
the Index when an index is over 30% fragmented. |
Reorganize
the Index when an index is between 10% and 30% fragmented |
| 3 |
Rebuilding
takes more server resources and uses locks unless you use the ONLINE option available in 2005 Enterprise and Development editions. |
Always
prefer to do Reorganize the Index |
| 4 |
T-SQL
for Rebuilding all Indexes of a particular table. USE AdventureWorks; GO ALTER INDEX ALL ON HumanResources.Employee REBUILD GO |
T-SQL for Reorganize all Indexes of a particular table. USE AdventureWorks; GO ALTER INDEX ALL ON HumanResources.Employee REORGANIZE GO |
No comments:
Post a Comment