HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMajor

Is there a reason to update statistics manually?

Submitted by: @import:stackexchange-dba··
0
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.