Articles & Content

Archives

Range Partitioning Fundamentals (E08)

Topic: 2007 NA

Subtopic: DB2 for LUW



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



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.