Re: Rollups -- one table or separate tables?

You might be interested in reading a bit about dimensions and materialized views, which, when used in combination, can greatly improve performance for such situations. Tom Kyte explains very well how to do this in his book ("Expert one-on-one Oracle"), chapter 13. If I didn't want to use dimensions-MVs, I'd define some views, instead of multiple tables.

Daniel

> When day values summarize to month, and month values to year, what are
> the pros and cons of storing the details (day records) and the
> summaries (month, year) in one table (the different records
> distinguished by an interval indicator, say Day, Month, Year) versus
> separate tables, one for day values, one for month values and the
> third for year values? Anybody had to make a decision on this, what
> did you choose, and why? thanks.
Received on Sun Nov 17 2002 - 06:47:45 CET