Schedule today!

Call Peggy at
  (800) 252-0652

Contact Us

More DB2

Related Courses

Advanced SQL Query Building

Recommended Duration:
3 Days
DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also.
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.
Major Topics
  • Relational access concepts
  • EXPLAIN and plan tables
  • Access strategies
  • Use of indexes
  • Filter factors
  • Indexable, stage 1, and stage 2 predicates
  • Joined access strategies - nested loop, merge scan, hybrid
  • Subqueries
  • Unions
  • Views and view performance
  • Cursor performance
There are five machine exercises.