Post reply

Is it require to update statistics after rebuilding index

  • April 18, 2012 at 4:36 am

    #256570

    Dear All,

    Is it require to update statistics after rebuilding index.

    As per my knowledge after rebuliding index we no need to run update statistics.But for re-org it's required.

    If we run after rebuild it will update the other statistics.If i run sp_updatestas o a database there will be no issue.

    If i am wrong kinldy guide me with clear idea.

    I have read in so many articles but i am having little confusion.Kindly suggest me on the same.

  • April 18, 2012 at 4:44 am

    #1475247

    When an index is rebuilt, the statistics on that index are updated as part of the rebuild. Hence there is not need to update that index's statistics, though there may still be need to update column statistics.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply