Instructor Led Db2 Optimizer Training
Db2 Optimizer Training Provider? - Tell us about your Training!
 online course |
 instructor-led class |
 learn at home |
 group study |
 self-directed study |
 cd-based training |
 DVD video training |
 printed book |
 e-book digital book |
 workshop seminar |
 train the trainer |
 computer-based learning |
 discount pricing |
 online tutorial |
From Affinity IT Training, LLC
DB2 -- Performance and Tuning
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC
'
s,
access methods, and how to write effective SQL predicates.
'
Explain
'
tables and tools are covered in detail as well as additional performance tools.
more...
This course provides experienced SQL developers with a fast-paced transition to DB2 performance and tuning.
Following a review of the DB2 architecture, environment, and data structures,
course coverage includes index internals, block index MDC
'
s,
access methods, and how to write effective SQL predicates.
'
Explain
'
tables and tools are covered in detail as well as additional performance tools.
more...
From Wintrac Inc.
DB2 for z-OS Application Performance Tuning
...ormance Considerations.
Discuss the "behavior" of the DB2 Optimizer.
Explore DB2 SQL performance issues as revealed by using the EXPLAIN feature.
The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail. The results of the DB2 EXPLAIN process are reviewed to obtain insights into the Way(s) that the Optimizer chooses the access path to access DB2 data.
Extensive
more...
