Date: Tue, 6 Jan 2009 23:01:10 +1100
> I got a oracle 10g database for datawarehousing.
> I dont know about datawarehousing concepts and the ways to performing
> tuning techniques applied in it.
> Please clarify me the following questions :
> For performance tuning and to know about the details of that
> database : In a datawarehouse database,
> 1. what are all the information should i get from the database ?
> 2. what are all the performance tuning techniques are applied ?
There's a good book on it by Bert Scalzo (spelling?) which deals with things like star schema optimization, parameter settings, etc.
Plus, of course, the doco/manuals.
GM Received on Tue Jan 06 2009 - 06:01:10 CST