Articles & Content
Topic: 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
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.