Thanks again, Dmitry.

Huan

2009/5/18 Dmitry Yemanov <dimitr@...>

>
>
> Huan Ruan wrote:
> >
> > For example, with a where clause like (FieldA = 'A' and FieldB = 'B'), if
> > FieldA has an index, FieldB has no index, and the optimiser decides to
> use
> > the index on FieldA, then it will always evaluate FeildA before FieldB.
> If
> > there are no indexes on either field, then it could evaluate FieldA first
> or
> > FieldB first depending on the compiler.
>
> Correct.
>
> Dmitry
>
>
>

[Non-text portions of this message have been removed]