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: 215

Filed under:
|

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

Related posts about sql-server

Related posts about statistics