469,578 Members | 1,423 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

UDB Range Partitioning in V8: Using Ranges in Constraints

According to the original whitepaper on UDB range partitioning (http://
www-106.ibm.com/developerworks/db2/library/techarticle/0202zuzarte/
0202zuzarte.pdf), you can use a range as a criteria, either in the
UNION ALL view or in constraints. One restriction it lists, though, is
that the optimizer can't use a constraint that references a range
versus a discrete value for SQL containing host variables or parameter
markers. That was for V7 and the document indicated this would change
in the future. It is now supported in V9 with the native range
partitioning capabilities of the CREATE TABLE statement. What about
V8? I'm working on an effort that would greatly benefit from range
partitioning (history table containing over 5B rows) but the natural
value to use for range partitioning is a date that is continuously
valued. We could add a discreet date (i.e., 1st of the month for each
month/year associated with one of the event dates) but unless users
always explicitely reference the 1st of the month date, we won't see
branch elimination. We could add the ranges to the UNION ALL view but
would prefer not invalidating all the other views in the system that
would be dependent on it.

Regards,
Nathan

Apr 24 '07 #1
0 1732

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Abhijit | last post: by
7 posts views Thread by Jane | last post: by
7 posts views Thread by Rajesh.............................. | last post: by
5 posts views Thread by sameer_deshpande | last post: by
10 posts views Thread by shsandeep | last post: by
reply views Thread by =?ISO-8859-1?Q?J=F6rg_Battermann?= | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.