Skip to content

DB2 10.5 Range Partitioned Tables Available in WSE

January 1, 2015

Figured I’d start off the new year with this tip. Unbeknowst to many, IBM included range partitioned tables in the WSE edition in 10.5. Additionally, you get up to 128GB per instance, up from 64GB. Range partitioned tables offer improved performance via partition elimination and availability improvements via reorg of partitioned indexes only. No need to reorg all indexes or none as is the case with non-partitioned tables. Stay tuned!

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: