IN conditions are search conditions with an IN predicate, to which the following rules apply:
· The operator is the operator IN.
·
IN conditions
have one of the following formats:
<column_spec
> IN (<extended_value_spec
>,...)
<column_spec> IN <subquery
>
The Optimizer can only use IN conditions that satisfy these prerequisites to determine an optimal search strategy.
Conditions in the format ...NOT (<column_spec> NOT IN (<extended_value_spec>,...)) or. ...NOT (<column_spec> NOT IN <subquery>)are, where possible, converted to an expression without NOT, and with a correspondingly negated operator. The system then continues processing the condition in this converted format.