Observation: Index and Data Page Offset
The offset from the index pages to the data pages exceeds the limit for a clustering index, which indicates clustering for the index is degrading. To improve the probability that the Db2 optimizer will use clustering index:
- Execute REORG to restore clustering
- Run RUNSTATS to update statistics
- Rebind affected plans.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*