Some predicates are transformed internally into ones that provide starting and stopping points and are therefore optimizable.

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 .