Help
Observation: LIKE Operator in Predicate and Column has Fieldproc defined
You coded a predicate using the LIKE operator on a column for which DB2 has a field procedure defined. In the example below column NAME has a field procedure defined.
SELECT
NAME, ADDRESS
FROM
EMP
WHERE
NAME LIKE 'FRED%'
This forces the predicate NAME LIKE 'FRED%' to become a STAGE II predicate. STAGE I predicates qualify rows earlier, and therefore reduce the amount of processing that must be done at STAGE II.
If the range of possible values is relatively small, consider recoding the LIKE predicate with either IN or BETWEEN, both of which are generally more efficient alternatives.