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

-4 votes

1 answer

205 views

sql-server sql-server-2019 statistics index-statistics

                          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?

Asked by variable (3590 rep)

May 13, 2022, 10:22 AM
Last activity: May 13, 2022, 10:42 AM

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

Related Questions