Grant Fritchey (6/27/2011)
It really depends on the volatility of the data, the structure of the indexes, and the types of queries run against it. We updated statistics on an insurance system I used to manage nightly for most databases. A few were weekly. We even had one table that, due to very poor construction, had it's statistics updated with a full scan once every 15 minutes. So there's no one right answer.
Full scan every 15 mintues????????????????
I sure hope it didn't take 14 minutes to complete that scan :w00t:.
Edited typo.