Catching inefficient access plans

Symptom

The STATS_TIME row indicates that the statistics are not updated.

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.