Re: update stats on partitioned tables

Starting with 10.2.0.4 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.

-Arul



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 10.2.0.4 on solaris.
>
> Thank you very much.
>
> Mayen




-- 
Arul

Other related posts: