patternsqlMajor
Is there a reason to update statistics manually?
Viewed 0 times
updatemanuallyreasonstatisticsthere
Problem
In SQL Server, statistics are updated automatically when
Auto Update Statistics in True (which is the default). Is there a reason to update statistics manually and in what circumstances?Solution
Sure, if your data is changing more frequently than the rate of auto stats (or, say, you are updating < 20% of the rows frequently, like updating statuses or date/time stamps). Or if your table is huge and it is not changing enough to trigger auto stats updates. Or if you have filtered indexes (since the auto stats threshold is still based on the % of change on the whole table, not the % of change of the subset of rows in the filtered index).
Context
StackExchange Database Administrators Q#12655, answer score: 21
Revisions (0)
No revisions yet.