Re: update stats on partitioned tables
Date: Thu, 2 Apr 2009 14:56:07 -0700
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.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 02 2009 - 16:56:07 CDT