Figure 9 5   A Visual Explain access plan graph

An access plan graph shows details of:

Tables (and their associated columns) and indexes

Operators (such as table scans, sorts, and joins)

Table spaces and functions

To get the details right click the desired graph element.

9.5  Initial tuning

Performance of a DB2 database application can be influenced by many factors 

such as the type of workload, application design, database design, capacity 

296 

MySQL to DB2 UDB Conversion Guide