Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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?
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.
