Re: Optimizer Stats collection for Datawarehouses

From: Greg Rahn <>
Date: Thu, 19 Nov 2009 09:04:17 -0800
Message-ID: <>

If the partition is not bulk loaded in a single shot, then a good way to deal with this is to clone partition stats ( dbms_stats.copy_table_stats in >= ) from another representative partition.

On Thu, Nov 19, 2009 at 7:11 AM, Mark W. Farnham <> wrote:
> One more thing, my earlier response was more about adding a new "empty"
> partition to be filled up in an OLTP or batch transaction context, and in
> the context of the thread being about datawarehouses, you should follow the
> "scaling to infinity" approach of swapping the partition in after you have
> already filled it. See Tim Gorman's paper on the topic and you'll likely
> make all the right choices.

Greg Rahn
Received on Thu Nov 19 2009 - 11:04:17 CST

Original text of this message