Articles & Content

Archives

Viper Preview: Range Partitioning Fundamentals (E10)

Topic: 2006 NA

Subtopic: DB2 for LUW



DATE: 2006-05-10 (02:30 PM - 03:40 PM)
SPEAKERS: Kevin Beck (IBM)

The table partitioning feature to appear in the upcoming Viper release of DB2 LUW provides a number of advantages. Data warehouse systems will especially benefit from easier roll-in/roll-out of data and better query execution performance. Data warehouse systems currently using union all views are particularly well suited to make use of table partitioning.

EXP. LEVEL: Beginner

OBJECTIVES:

Intro to Table Partitioning

Defining Partitioned Tables

Roll-in/Roll-out Using Attach/Detach

Performance Considerations

Migration and Other Topics



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.