471,888 Members | 2,279 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,888 software developers and data experts.

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 1780

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 zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.