Re: update stats on partitioned tables

From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Thu, 2 Apr 2009 15:06:39 -0700
Message-ID: <1c1a62990904021506q3fe6dad7k1e1d7ce6fd6cd1a8_at_mail.gmail.com>

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_at_lazard.com> 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

--
http://www.freelists.org/webpage/oracle-l

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