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
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
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
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:
4 matches
Mail list logo