• GilaMonster (1/12/2012)


    sp_update stats has threshold of rows that must have been changed since the last stats update for it to update them again. As Grant says in his article

    then, you run sp_updatestats… Which will go through the whole table, determining if any data has changed and the statistics need to be updated. “Any data” reads, one row. So if even a single row has been modified since the last time the statistics were updated

    Yes, that threshold is a single row.

    Thanks Gail, so it makes sense to run the maintenance in this order:

    1. sp_updatestats

    2. ALTER INDEX...REBUILD/REORGANIZE

    Thanks again 🙂


    Sujeet Singh