0 Replies Latest reply: Oct 27, 2012 1:08 PM by 905989 RSS

    keeping stats up to date for partitioned tables

    905989
      Hi,

      Oracle version 10.2.0.4

      I have a partioned table. I would like to keep stats up-to-date.

      Can I just run a single command to update table stats, indexes and partitions please?
      exec dbms_stats.gather_table_stats(user, 'TABLE', cascade=>true)
      or I also need to run exec dbms_stats.gather_table_stats(user, 'TABLE', granularity=>partition)

      thanks,

      Ashok

      Edited by: 902986 on 27-Oct-2012 11:06

      Edited by: 902986 on 27-Oct-2012 11:07