At 11:47 AM 2/13/2003 +0200, Alexander Tabakov wrote:

>Hi again,
>
>Does anybody know the order in which the predicates from the WHERE clause
>of a SELECT statement execute.
>
>For example
>
>WHERE
> PREDICATE_1 and PREDICATE_2 and PREDICATE_3

It's not determinant. The optimizer will select what it
considers the most efficient order.


Regards,

Ann
www.ibphoenix.com
We have answers.