Avoid index probing in DB2 10
agburke 060001QPDN Visits (1325)
In V10 we began using index probing to re-validate in certain cases to ensure we do not get into a tablespace scan that we believe is empty when there are actually a million rows in it.
Used when one of the following is true...
You can use the following methods to disable index probing:
1. Have current, up-to-date statistics (run RUNSTATS)