Share via

EXEC sp_updatestats.

Doria 1,246 Reputation points
2020-09-02T02:34:42.777+00:00

Hi everyone!

Why is the date not updated after executing the command 'EXEC sp_updatestats;' on the database?

22095-untitled.png

All help is welcome!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,171 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,966 Reputation points Microsoft Vendor
    2020-09-02T06:11:41.233+00:00

    Hi Doria,

    Since the last time statistics were updated, the above tables have not been modified(modification_counter=0). Therefore, these tables have been excluded from the statistics update operation.
    For more details, please refer to this article which might help.

    Best Regards,
    Amelia

    =======================================
    Please remember to click " Accept Answer" and upvote the responses that resolved your issue.

    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. SQLZealots 276 Reputation points
    2020-09-02T02:38:44.02+00:00

    BOL sys...
    sp_updatestats updates only the statistics that require updating based on the rowmodctr information in the sys.sysindexes catalog view, thus avoiding unnecessary updates of statistics on unchanged rows

    Ref: https://sqlperformance.com/2013/07/sql-statistics/statistics-updates

    0 comments
  2. Doria 1,246 Reputation points
    2020-09-02T12:36:23.43+00:00

    Thanks all, I got it!

    Regards.

    0 comments