Is the effect of statistics update immediate or does sql server need to be restarted?

All we need is an easy explanation of the problem, so here it is.

Index statistics are utilized by sql server to derive the best plan for query execution.

Suppose I update the index statistics then can existing queries use the effect of updated statistics or does sql server need to be restarted so that the cached plans are reset?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

Updating the statistics would invalidate the plans in the cache, and the new plans would make use of the new statistics.

Further, even if there were a scenario that warranted clearing the cache, there are many much less invasive methods than restarting SQL Server, such as DBCC FREEPROCCACHE.

However, very rarely should you ever need to clear the entire cache.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply