1 Reply Latest reply: Apr 4, 2008 2:01 AM by 450470 RSS

    updating stats on all tables

    626015
      I'm needing to update statistics on all tables in a schema, is there a command to do this without writing a script to do so?

      Also, I have 15 schemas in my database, would it be possible to do an update stats on all the tables in each schema, under 1 command without logging iinto each schema seperately.

      Thanks