Index rebuild and reorganize
After how many days Index should be rebuild or reorganize in sql server??
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
RobbinsonPosted Oct 22, 2013, 3:29 AM
Recommendation is Index should be rebuild when fragmentation is greater than 40% and Index should be reorganized when fragmentation is between 10%-40%. Index rebuilding process is CPU intensive process and locks the database resources.if you are using Enterprise version then it has option ONLINE which keep index available during rebuilding.
For more details about how to plan your index maintenance, please refer below article
http://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
Hope, this will help you out.
Please Don't forget to mark as answer if this post helps you.
Jignesh TrivediPosted Oct 22, 2013, 12:32 AM
hi,
This is depending upon how may insert update fire on table on which you are going to create index.
http://technet.microsoft.com/en-us/library/ms189858.aspx
hope this will help you.