locked
Auto Update Statistics RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have Auto Update Statistics enabled in a database. I have a Statistics Created for a Column. I made a update of around 50K rows for the same column. After the updates when I looked into the Statistics Detail it has not changed. I waited for few mins and looked at it again and again found no change.

    But when I issued a select query with filter on the column statistics was created , the statistics details got changed to correct value.

    What is happenning ?

    Shouldnt the statistics update itself as soon as the update was made and not wait for any query to be issued ?

    Thanks,

    Tuesday, December 27, 2011 10:06 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    No, statistics are typically updated when SQL Server needs to run a query. This white paper discusses how SQL Server uses and maintain statistics:
    http://technet.microsoft.com/en-us/library/dd535534(SQL.100).aspx

    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Proposed as answer by Vinay Valeti Tuesday, December 27, 2011 11:09 PM
    • Marked as answer by nadirsql Wednesday, December 28, 2011 2:12 AM
    Tuesday, December 27, 2011 10:26 PM