A static IN list predicate is one in which the IN list is composed entirely of constants. 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'