Re: Optimizer Stats collection for Datawarehouses
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- Date: Thu, 19 Nov 2009 18:10:31 +1100
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@xxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l
Other related posts: