Re: Optimizer Stats collection for Datawarehouses
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Thu, 19 Nov 2009 18:10:31 +1100
Message-ID: <4B04EF67.8030809_at_iinet.net.au>
Sanjay Mishra wrote,on my timestamp of 19/11/2009 2:37 PM:
Date: Thu, 19 Nov 2009 18:10:31 +1100
Message-ID: <4B04EF67.8030809_at_iinet.net.au>
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.
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 19 2009 - 01:10:31 CST