# Static IN predicate transformations

A static IN list predicate is one in which the IN list is composed entirely of constants. Derby calculates the minimum and maximum values in the list and transforms the predicate into three new predicates: the original IN predicate, one that uses the >= operator, and one that uses the <= operator. The second and third are optimizable. For example:

    orig_airport IN ('ABQ', 'AKL', 'DSM')

is transformed into

    orig_airport IN ('ABQ', 'AKL', 'DSM')
    AND orig_airport >= 'ABQ'
    AND orig_airport <= 'DSM'

- NOT IN predicate transformations

Parent topic: Predicate transformations
Related reference
BETWEEN transformations
LIKE transformations
OR transformations