Articles & Content

Archives

Range Partitioning Fundamentals (E08)

Topic: DB2 for LUW

Subtopic: 2007



DATE: 2007-5-8 (04:20 PM - 05:20 PM)
SPEAKERS: Kevin Beck (IBM)

The table partitioning feature, new in DB2 9 provides a number of advantages.Data warehouse systems will especially benefit from online roll-in and roll-out of data.Paritition elimination offers better query execution performance for many common business intelligence style queries.Data warehouse systems currently using union all views are particularly well suited to make use of table partitioning.

EXP. LEVEL: Intermediate

OBJECTIVES:

Understand the benefits of table partitioning

Learn how to create range partitioned tables appropriate to your needs

Learn how to use table partitioning to accomplish online roll-in

Learn how to use table partitioning to accomplish online roll-out

I will share some performance data about the behavior of table partitioning in common scenarios



Click Here to Download

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