IBM Books

Catching inefficient access plans

Symptom

The STATS_TIME row indicates that the statistics are not updated.
Figure rule not displayed.

Possible cause

The optimizer used default values. (These default values are displayed with the keyword "default".) This situation can result in an inefficient access plan,

Action

It is recommended that you use the runstats command to update the statistics; then rebind the package.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]