Predicate Ordering

In the absence of an ORDERED_PREDICATES hint (), predicates (except those used for index keys) will be evaluated in the order specified by the following rules:

• Predicates without any user-defined functions, type methods, or subqueries are evaluated first, in the order specified in the WHERE clause.

• Predicates with user-defined functions and type methods which have user-computed costs are evaluated in increasing order of their cost.

• Predicates with user-defined functions and type methods that have no user-computed cost are evaluated next, in the order specified in the WHERE clause.

• Predicates not specified in the WHERE clause (e.g., predicates transitively generated by the optimizer) are evaluated next.

• Predicates with subqueries are evaluated last in the order specified in the WHERE clause.