Privet Sasha!

At 11:47 13.02.2003 +0200, you wrote:

>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
>
>which one is first

I think this is determined by the plan. The plan tries to retrieve the
records as cheap as possible, and will start by evaluating what it
perceives to be the most restrictive predicate having an index (please
correct me if I'm wrong).

Set