Re: update stats on partitioned tables

From: Arul Ramachandran <>
Date: Thu, 2 Apr 2009 15:06:39 -0700
Message-ID: <>

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, <> 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


Received on Thu Apr 02 2009 - 17:06:39 CDT

Original text of this message