Course Code: G-555
Recommended Duration: 2 Days
The student will learn to use the EXPLAIN facility to understand physical access paths in DB2, to practice developing complex queries, and to assess the performance implications of various SQL coding techniques.
Experienced DB2 programmers who need to construct complex, efficient queries using SQL, or who need to tune existing complex queries for performance.
Experience coding SQL queries, using either SPUFI or QMF.
Related IBM Materials
This course is drawn from this IBM manual; access to it in the classroom
is desirable but not required:
DB2 SQL Reference (current version)
Major Topics Include
There are seven machine exercises