Providing Technology Training and Mentoring For Modern Technology Adoption
This course describes how the correct design of indexes can improve query performance for both single and multiple table access. It covers the different methods by which an index may be utilised by DB2, such as matching and non-matching index scans, index screening, index lookaside and use of multiple indexes and list prefetch. The factors involved in determining the best index to use to satisfy a given statement are also discussed. Different types of index are covered, as well as many of the design options available (such as the column sequence of a multiple column index) and the options available when the index is defined. Interpreting catalog columns and running relevant utilities to maintain index performance are also explained.
On successful completion of this course attendees will be able to:
This course is suitable for DB2 database administrators and application developers who are responsible for index design for queries in a DB2 for z/OS environment.
A good understanding of DB2 and SQL queries.