• 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.