Reorganizing Indexes

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 400
Sometimes the huge/Bulk DML operation leads to Index performance degration.... to overcome this type of issues, we suppose to either reorganize/rebuild the indexes periodically....

First get the Index fragmentation percent of each index,
If fragmentation percent is >= 5 and <30 then we will go ahead with REORGANIZATION of that index....

ALTER INDEX ALL
ON TableName REORGANIZE


It reorganizes the leaf nodes of the index physically

Comments or Responses

Login to post response