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 (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
Next Post
SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.

Related Posts

5 Comments. Leave new

  • Tharindu Dhaneenja
    September 20, 2010 4:55 pm

    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”?

    Reply
  • 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.

    Reply
  • 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.

    Reply
  • 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

    Reply
  • Your external link is broken.

    Reply

Leave a Reply

Menu