[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

SP_autostats is "ON" but Last updated column is three months old

Hi Experts,
I ran Exec SP_autostats Employee... the AUTOSTATS cloumn is "ON" for all indexes, but the last update shows Jul (more than three months ago)

Can someone explain what is missing here?
0
sir-rob
Asked:
sir-rob
1 Solution
 
momi_sabagCommented:
even with autostats, statisitcs are collected only when some thresholds are being met
if your table hasn't been updated much in the last 3 months, it is possible that the statistics that were calculated 3 months ago are still relevant and that is why sql server didn't update them
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now