For example:
SELECT * FROM Flights
WHERE flight_id = 'AA1111'
AND segment_number <> 2
In this example, the first
predicate
is optimizable; the second predicate is not. Therefore, the statement is
optimizable.
In a few cases, a WHERE clause with predicates joined by OR can be
transformed into an optimizable statement. See
.
can transform some
predicates internally so that at least one of the predicates is optimizable and
thus the statement is optimizable. This section describes the predicate
transformations that
performs to make predicates optimizable.
A predicate that uses the following comparison operators can sometimes be
transformed internally into optimizable predicates.