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