BETWEEN Transformations

A BETWEEN predicate is transformed into equivalent predicates that use the >= and <= operators, which are optimizable. For example:

flight_date BETWEEN DATE('2004-04-01') and DATE('2004-04-10')

is transformed into

flight_date >= DATE('2004-04-01')
AND flight_date >= '2004-04-10'