Re: Optimizer Stats collection for Datawarehouses

From: Nuno Souto <>
Date: Thu, 19 Nov 2009 18:10:31 +1100
Message-ID: <>

Sanjay Mishra wrote,on my timestamp of 19/11/2009 2:37 PM:

> One example is that if there monthly
> partition table containing several Gig data and when new partition
> created and utiliZed can experience some performance slowness on the
> first day of the month. and so

The approach I take is:
The application knows when to calculate stats. Not the database. As such, if the creation of the new partition is a monthly maintenance job/script/package/procedure, then add the stats calculation to the end of it.

Nuno Souto
in sunny Sydney, Australia
Received on Thu Nov 19 2009 - 01:10:31 CST

Original text of this message