Indirectly optimizable predicates

Indirectly optimizable predicates Some predicates are transformed internally into ones that provide starting and stopping points and are therefore optimizable. Predicatesindirectly optimizable Internal transformation of statements

Predicates that use the following comparison operators can be transformed internally into optimizable predicates:

BETWEEN
LIKE (in certain situations)
IN (in certain situations)

For details on these and other transformations, see .