When do Statistics get updated?

,

Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when statistics get updated - and where we might have to update them ourselves.

This post details in what scenarios statistics get updated, as well as the thresholds used for automatic updating of statistics.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate