Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping statistics as accurate as possible will give the optimizer the information it uses to calculate estimated costs and cardinality, which enables it to properly allocate resources such as memory grants. In this blog I am not going to go into what statistics are and how they are used.
source https://www.c-sharpcorner.com/article/keeping-large-table-statistics-current-tf2371/
No comments:
Post a Comment