Post reply

update stats

  • April 2, 2013 at 1:37 am

    #272979

    How update stats works in sql ?

  • April 2, 2013 at 2:11 am

    #1602691

    In what sense? What problem are you trying to solve here?

    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

  • April 2, 2013 at 2:27 am

    #1602698

    what actually will work when we run the update stats ona database ?

  • April 2, 2013 at 2:44 am

    #1602703

    The column that the stats are on is read, the data distribution calculated, the buckets for the histogram selected and populated, the new statistic object written to the database.

    Again, what problem are you trying to solve here?

    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 4 posts - 1 through 3 (of 3 total)

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