Re: update stats on partitioned tables

From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 2 Apr 2009 14:56:07 -0700
Message-ID: <a9c093440904021456x65dfa88dkd162758a549364d6_at_mail.gmail.com>

I would recommend:
- gather partition stats (granularity=>'partition') - gather table stats (granularity=>'global')

Gather partition stats for the loaded partitions, then gather global stats. This will save the time of gathering stats on data that has not changed.

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

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Apr 02 2009 - 16:56:07 CDT