Observation: Hybrid Join and Low Cluster Ratio
You coded a hybrid join with an inner table that has an index with a cluster ratio less than 80. The DB2 optimizer will invoke a sort on the inner table.
To improve the probability of the Db2 optimizer using the clustering index:
-
Execute REORG to restore clustering.
-
Run RUNSTATS to update statistics.
-
Rebind affected plans.