UDB Range Partitioning in V8: Using Ranges in Constraints

This is a discussion on UDB Range Partitioning in V8: Using Ranges in Constraints within the ibm-db2 forums in Other Databases category; 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 ...

Go Back   Database Forum > Other Databases > ibm-db2

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 04-24-2007, 08:08 PM
Default 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

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 10:11 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.