DB2 Large Partitioned Table Space Design & Performance
| Course Code: | DZOLPT |
| Duration: | 1 day |
| Audience: | Application Developers, Database Administrators, Data Warehouse Specialists and Capacity Planners. |
| Prerequisites: | A working knowledge of DB2 objects and architecture. |
| Summary: | This course places especial emphasis on the design,
implementation and performance of large tables; our
definition of a large table is one of 500MG or greater.
However, the course discusses why smaller tables should
be partitioned if they are to be joined with large tables. As parallelism is a complementary functions, it is discussed as an integral aspect of partitioning. |
| Objectives: | Upon completion of this presentation, the participant should be able to design partition tables and related indexes to optimise performance. Additionally, the delegate should be able to use the DB2 EXPLAIN and accounting reports to determine if parallelism goals are being met. |
 Detailed Outline |
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
