| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Weekly aggregates
Gurelei
Absolutely you can partition by week. The creative DBA is a top DBA! You keep mentioning aggregation. Have you considered Materialized Views?
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: Gurelei [mailto:gurelei_at_yahoo.com]
Sent: Thursday, March 20, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Subject: Weekly aggregates
Hi all:
An application I'm supporting needs weekly aggregates. Nothing wrong with that except I'm thinking of how to partition that aggregate table. The requirement is to keep 3 year history of data. I have been partitioning other aggregate tables (monthly etc) by month. This makes it easy to drop old partitions AND Oracle can use the partitions to reduce the size of the data for some queries. I'd like to keep the montly partitioning in for the uniformity reasons, but weeks do not lay over months, a week can span two months and therefore the usefulness of partitions for some of the reports will be reduced. I'm wondering how do others approach this. Do people partition weekly aggregates by week instead of months? ANy other thoughts?
thanks
Gene
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Mar 20 2003 - 14:15:30 CST
 |
 |