Home » Tutorials » SQL SERVER » Performance Improvement in SQL » Rebuild and Reorganize Indexing Sql Server Scripts

Rebuild and Reorganize Indexing Sql Server Scripts

Attach Console with WPF application
Get all installed fonts in your computer using C#

Rebuild and Reorganize Indexing Sql Server Scripts

Hello Folks, today I will explain regarding when and why we should Rebuild or Reorganize Index in Sql Server regularly.

There is a simple rule behind Rebuild and Reorganize indexes which is shown in MSDN as below:



See as per MSDN when avg_fragmentation_in_percent’s value is in between 5 % to 30%, we have to do reorganize indexing, but when its more than 30% we should do Rebuild Index with (ONLINE = ON).

Below is the standard script for Rebuilding and Reorganizing Indexes:

You can also download Rebuild and Reorganize Indexing Sql Server Script.


Hello friends, My self Dhruv Sheth, I have more than 6 years of Industrial experience as a Software Developer. In my career I got chance to work with asp.net, c#,Web API, JavaScript, JQuery, WPF, WCF , Windows Application, PostScript, vb.net, GhostScript etc. So I have decided to share my knowledge with everyone and finally I have come up with TechnoThirsty.

Leave a Reply

Your email address will not be published. Required fields are marked *


Time limit is exhausted. Please reload CAPTCHA.

The content is copyrighted to technothirsty.com and may not be reproduced on other websites without permission from the owner.You may contact us using the information below.