Re: Update Statistics

In article <2026@das13.snide.com>, dave@das13.snide.com (Dave Snyder) writes: |> I remember while working for a company, that had 550+ tables in their Online |> database, we always ran into some type of problem with UPDATE STATISTICS on |> the whole database. Either we were running out of locks or blowing the logs |> away, I forget which. Whatever the problem was I was forced to write the |> following script to work around the it: [ script deleted] Probably logs, since the update to each system catalog entry is going to be logged. With 550+ tables, that's a lot of updates. It's always best, when possible, to run update statistics on individual tables. Dave