Re: Use for CREATE DIMENSION in O10g?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Fri, 26 Mar 2004 07:59:58 GMT
Message-ID: <2qR8c.125123$Wa.28974@news-server.bigpond.net.au>

"John Haskins" <donoteventrytospamme_at_thisaddress.com> wrote in message news:pvadndQANc-MKv7dRVn-uA_at_adelphia.com...
> Aha, thanks. So would this be a fair summary: by suggesting to the CBO
> where a more-granular materialized view can be rolled up into larger
grains,
> it saves storage space at the possible expense of some processing speed?
> (Since the granular materialized view's data will need to be summed in
real
> time to, for instance, present quarterly subtotals instead of monthly.
>
> Appreciate you sticking with this.
>

John,

That is a fair summary. You are catching on fast. And thank you for kind words.

Douglas Hawthorne Received on Fri Mar 26 2004 - 01:59:58 CST