SQL Server : Weekly update statistics job
Posted
by Manjot
on Server Fault
See other posts from Server Fault
or by Manjot
Published on 2010-05-12T23:07:52Z
Indexed on
2010/05/12
23:14 UTC
Read the original article
Hit count: 209
sql-server
|statistics
Hi,
On a SQL server, why do we need a weekly update stats job (with full scan) when we have AUTO_UPDATE_STATISTICS=ON for all databases?
Doesn't this option update statistics all the time?
Regards
© Server Fault or respective owner