Automated updates
1 post1 contributor
+ FollowBe the first to follow this
Write about itArticles about Automated updates
Keeping Large Table Statistics Current - TF2371
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.
