Re: Please HELP ME !!!

Posted in 1997

Peter Lancashire — Thu, 18 Sep 1997 17:32:02 +0100 — source: Informix-list mailing list archive (1991-1998)

Jarek wrote: > > When I make not important change in WHERE clause result is completly > different. Please read it down... > Sory, don't have time to do this just now, but a good way to analyse this sort of thing is to draw a diagram of all your tables and joins. I suspect you may not have enough joins amongst your tables. The optimiser changes the query depending on the where clause, so you get problems. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.