On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.
Is it possible that your statistics are many years old but still are valid? It is difficult to find Outdated Statistics is not as easy as it seems.
The word which they had used was Outdated Statistics. Let us learn more about it in today’s blog post. Find Oldest Updated Statistics
After careful investigation, we figured out the cause for not auto-updating statistics. Let us learn about that today with STATISTICS_NORECOMPUTE.
Today we will see how we can update Column Statistics via SSMS (SQL Server Management Studio). This feature was broken earlier and now fixed in SSMS 18.6.