Re: slooow query using JOIN

2002-03-07 Thread Stephen Moretti
Adrian, > > It is terrible (60 seconds) when run like this: > SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON a.id > = b.id AND b.ff3 = 'T' > WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' > It may be total rubbish, but have you tried rotating the

Re: slooow query using JOIN

2002-03-07 Thread Nick de Voil
Adrian > It is terrible (60 seconds) when run like this: > SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON a.id > = b.id AND b.ff3 = 'T' > WHERE b.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' How about the id fields in both tables, are they indexed? Ni

RE: slooow query using JOIN

2002-03-06 Thread Chuck McElwee
27;somevalue' and id = a.id and ff3 = a.ff3) Just a suggestion... Chuck McElwee etech solutions inc www.etechsolutions.com -Original Message- From: Adrian Cesana [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 7:41 PM To: CF-Talk Subject: slooow query using JOIN This qu

slooow query using JOIN

2002-03-06 Thread Adrian Cesana
This queries performance is acceptable (about 1 second) when run like this: SELECT a.f1,a.f2,b.ff1,b.ff2 FROM table1 a LEFT OUTER JOIN table2 b ON a.id = b.id AND b.ff3 = 'T' WHERE a.mydate BETWEEN '3/4/2002' AND '3/6/2002' AND b.ff4 = 'somevalue' It is terrible (60 seconds) when run like this: