469,270 Members | 1,205 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

Range Partitioning

I have 2 questions regarding DB2 9's Range Partitioning.
1. Do the Partition fields have to reside on the table being Partitioned? We have a Fact table we would like to Partition and the Week identifier resides on the table. This identifier's parent Dimension table has a month value. In order to Partition the Fact table by month, somehow the Dimension table would need to be referenced.

2. The Fact table mentioned in the above paragraph is approximately 1 Terabyte and as mentioned, contains weekly level data. There are approximately 4 to 6 million rows per week. Are there enough rows to create a partition at this level or would we need to create the partition at a monthly level, which would be approximately 24 million rows. Is there a lot of overhead in creating 52 partitions per year versus 12. We plan on having 5 years of history and on that 6th year, begin dropping partitions either weekly or monthly, depending on the partitioning strategy we use. Is there much more overhead in the weekly versus monthly partition dropping.
May 23 '07 #1
0 1565

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Jane | last post: by
7 posts views Thread by Rajesh.............................. | last post: by
1 post views Thread by pramod.barthwal | last post: by
reply views Thread by Robert Klemme | last post: by
10 posts views Thread by shsandeep | last post: by
2 posts views Thread by Justin | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.