Rollups -- one table or separate tables?

From: Gene Kahn <jenjhiz_at_yahoo.com>
Date: 15 Nov 2002 19:54:19 -0800
Message-ID: <4d3f9c15.0211151954.5e0bb592_at_posting.google.com>

Hi,
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 Sat Nov 16 2002 - 04:54:19 CET

This message: [ Message body ]
Next message: Oliver Yao: "How to write simple select clause for the following problem"
Previous message: Steven: "Oracle .NET Provider for different releases"
Next in thread: Daniel Roy: "Re: Rollups -- one table or separate tables?"
Reply: Daniel Roy: "Re: Rollups -- one table or separate tables?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message