This section contains a list of related Visual Explain
reference topics that might be helpful to you.
Guidelines for creating indexes
Creating appropriate indexes allows the optimizer to choose
an index scan for those cases where it would be more efficient than
a table scan.
Out-of-date access plans
If your access plans are out-of-date, you need to update
the statistics; then rebind the package.
Using RUNSTATS
The optimizer uses the catalog tables from a database to
obtain information about the database, the amount of data in it, and
other characteristics, and uses this information to choose the best
way to access the data.
DB2 Version 9.7 for Linux, UNIX, and Windows