Articles & Content

Archives

Range partitioning in DB2 UDB (E02)

Topic: 2005 NA

Subtopic: DB2 for LUW



DATE: 2005-05-23 (12:30 PM - 01:40 PM)
SPEAKERS: Paul Brett (IBM Data Management)

A future release of DB2 UDB will include range partitioning. This feature allows a table to be split up by ranges of values which allows - Easy online rollin/rollout - efficient query processing via partition elimination In addition several other new features will be discussed including the ability to place multiple indexes for one table in different tablespaces.

EXP. LEVEL: Beginner

OBJECTIVES:

What is range partitioning?

Rollin/rollout of data

Performance enhancements - Partition elimination

Very large tables

Practical tips and advice



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.