>
> 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.