Auto Update Statistics RRS feed

  • Question

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


    Tuesday, December 27, 2011 10:06 PM


  • No, statistics are typically updated when SQL Server needs to run a query. This white paper discusses how SQL Server uses and maintain statistics:

    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