Re: DataWarehousing

From: Geoff Muldoon <>
Date: Tue, 6 Jan 2009 23:01:10 +1100
Message-ID: <>

raja says...

> 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.

Read lots.

GM Received on Tue Jan 06 2009 - 06:01:10 CST

Original text of this message