Articles & Content
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
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.