| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
 |
 |