Re: 2 million row database from hell! help a newbie in over his head.
From: David Cressey <david_at_dcressey.com>
Date: Fri, 24 Aug 2001 13:28:14 GMT
Message-ID: <ODsh7.308$Iw2.21893_at_petpeeve.ziplink.net>
Date: Fri, 24 Aug 2001 13:28:14 GMT
Message-ID: <ODsh7.308$Iw2.21893_at_petpeeve.ziplink.net>
Carl,
> not what I was talking about though. I was suggesting an aggregate
table(s)
> to contain popular report data. We have used this quite a bit to transfer
> the load of performing popular aggregates to off peak hours.
>
This sounds quite a bit like what Kimball calls "declaring the grain". Am I
reading you correctly?
--
Regards,
David Cressey
www.dcressey.com
Received on Fri Aug 24 2001 - 15:28:14 CEST