Re: update stats on partitioned tables

  • From: Arul Ramachandran <contactarul@xxxxxxxxx>
  • To: Mayen.Shah@xxxxxxxxxx
  • Date: Thu, 2 Apr 2009 15:06:39 -0700

Starting with you can consider using DBMS_STATS.COPY_TABLE_STATS to
copy stats from a previous partition to the new partition. This would ensure
your execution plans are the same across all partitions.


On Thu, Apr 2, 2009 at 12:51 PM, <Mayen.Shah@xxxxxxxxxx> wrote:

> Hello Everyone,
> Can some one please guide me to document/links for best practice for
> updating stats for partitioned tables and indexes?
> We have an application where data gets loaded on monthly basis. Typically
> after each load we update full stats on all tables in which data gets
> loaded. This takes long time. We are thinking of updating stats only for
> partitions in which data have been loaded. Is this better method? If we
> collect stats on one or two partitions, how does global stats gets updated?
> Version on solaris.
> Thank you very much.
> Mayen


Other related posts: