Find if stats were stale for a table

  • Hi,

    How do we find if tables stats were stale? I'm running update stats daily with default scan but want to know if default is enough for all tables or not.

  • When the stats are considered stale is subjective - there is no clear cut way to say they are stale. Generally you can look at how many rows were modified since the statistics were last changed and then you decide from there. Most of the scripts will look at the number of modified rows, last time stats changed to get an idea but a lot of times it's the query plans and the estimated row counts that tell you when stats need to be updated. This article has further explanation and an example script:

    How to Find Outdated Statistics?

    Sue

     

Viewing 2 posts - 1 through 1 (of 1 total)

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