SQL SERVER – Index Reorganize or Index Rebuild

Recently, I have received one question quite often about when to Index Reorganize and when to Index Rebuild.

I have already written about this topic earlier but it seems that many are unable to search it.

SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script

If you have any question you can search exclusively SQLAuthority at http://search.SQLAuthority.com

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

5 thoughts on “SQL SERVER – Index Reorganize or Index Rebuild

  1. Hi Pinal,
    can you pls explain what is the storage level different between Index Reorganize or Index Rebuild. we know “Index Rebuild” means drop existing index and recreate it. but what is behind of “Index Reorganize”?

    Like

  2. Hi Pinal,

    I have created a DWH for one of our customers on SQL server 2008 R2. I have non-clustered indexes on the tables. Now I am facing issue in following conditions.
    1> If I disable the indexes on these tables then my DWH get updated very fast from OLTP system but my reporting becomes slow.
    2> If I don’t disable the indexes then DWH updates takes ages.

    I request your help in this.

    Like

  3. The Normal Practice is Disable All your Non-Clustered index -> perform your Data load -> Rebuild your all non-cluster indexes.

    Data load speed also depend on how did you create your clustered index. If your cluster key is sequential like auto id or sequentialGUID, this will faster your insert performance.

    Lot of people also follows Drop Non-clustered indexes -> Drop Clustered indexes -> Load your data -> recreate Clustered index -> recreate non-clustered indexes. this will be really help full when you do not have sequential cluster key.

    Pinal i have read your lot of articles but this is my first post as a reply. correct me if i am wrong.

    Like

  4. Hi Pinal,

    My job profile involves lot of work towards SQL Server side. Everytime I am stuck with some problem, I start googling about and find one of your links that always helps. Thanks a lot for such a great material you have on your blog. Do you have anything that explains how to analyze query execution plans? If you could share that with me over my email.

    Regards
    Sachit

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s