This discussion is archived
0 Replies Latest reply: Oct 27, 2012 11:08 AM by 905989 RSS

keeping stats up to date for partitioned tables

905989 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points