Observation: Many Index Leaf Pages
The number of active leaf pages exceeds the limit for an index. Non-matching index scans can be costly on large indexes. Generally, performance improves with a matching column index. Add additional local predicates to influence the Db2 optimizer to use matching columns.
If there are no additional predicates to add, and the statement uses a cursor, consider using the CURSOR WITH HOLD option to avoid losing the cursor after COMMIT processing.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*