Re: Set explain use

5.[00-03].XXX has a known problem with the Optimizer... On some platforms it goes beyond 5.03 (Sequent for one)... Eric NoSpam@StratCon.com on 11/19/97 01:46:09 AM Please respond to NoSpam@StratCon.com To: informix-list@rmy.emory.edu cc: (bcc: Eric Melillo/AGInc) Subject: Re: Set explain use satriguy@aol.com (SaTriGuy) wrote: >>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 It should not matter. But, a couple of years ago I found out that it did! After all else failed, I just tried flipping them and BANG! my performance problem was solved. I was using 5.0? I think. Danni DBauer@StratConInc.com http://www.StratConInc.com