5.11.5 Equivalent exchange for an IN predicate
If only one comparison value is specified in the IN condition, equivalent exchange is performed on the specified search condition. If equivalent exchange has been performed on search conditions, the indexes to be used during retrieval are determined based on the search conditions obtained after equivalent exchange.
The following shows examples of equivalent exchange. In the examples, C1 is a column name.
- Organization of this subsection
(1) Example 1
![[Figure]](GRAPHICS/F0000074.GIF)
- Explanation:
-
If only one comparison value is specified in the IN condition, the search condition is converted to the = condition.
(2) Example 2
![[Figure]](GRAPHICS/F0000075.GIF)
- Explanation:
-
If only one comparison value is specified in the NOT IN condition, the search condition is converted to the <> condition.