Re: Set explain use

>Not considering indexes, does it make any difference to the informix >optimizer > if we switch the order of conditions in a where clause. For example, which >one > is better: > >select * from A where p = q and r = s or >select * from A where r = s and p = q .> >None of p,q,r, and s is indexed. Nope - not this this query. The optimizer will treat an "and" condition as an "equiviliant" and will consider both when creating the query plan. Madison Pruet