RE: Optimizer Stats collection for Datawarehouses
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <mwf@xxxxxxxx>, <jaromir@xxxxxxxxxxxx>, <smishra_97@xxxxxxxxx>
- Date: Thu, 19 Nov 2009 10:11:11 -0500
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.
<snip>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
