Post reply

Basic about Index statistics

  • August 29, 2013 at 2:40 am

    #276625

    Just run into 2 contrary articles, where one says the Index Statistics are Updated when the index is rebuild or reorganised. Other says that they remain constant.

    Logically according to me they should remain as they are. But just to clear the doubt i posted it her.

  • August 29, 2013 at 2:58 am

    #1645893

    They're both wrong.

    Statistics associated with an index are updated with the index is rebuild. A reorganise does not touch the stats. Stats other than the ones on the index are untouched by rebuilds

    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

  • August 29, 2013 at 3:17 am

    #1645896

    Thanks Gila Monster for a quick reply 🙂 !!!!

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

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