Exploiting the DB2 Optimizer
| Course Code: | DZOOPT |
| Duration: | 1 day |
| Audience: | Database Administrators, System Administrators, Application Developers, Programmers and System Programmers. |
| Prerequisites: | A working knowledge of SQL predicate types, I/O types and SQL statements such as SELECTs, UPDATEs, JOINs, UNIONs, etc. |
| Summary: | This course uses information gained from our instructor's
empirical knowledge coupled with that gained from a variety
of IBM capacity planning and other publications to
consolidate conclusions about the DB2 Optimizer. These
conclusions, when observed, should assist those
concerned with SQL and application performance in
optimising the following:
|
| Objectives: | Upon completion of this presentation, the participant should be conversant with how the DB2 Optimizer for z/OS chooses an access path, how the user can override the chosen access path, etc. |
 Detailed Outline |
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
