I'm on 7.3.4 and this query gets horrible performance. Is there a way to rewrite it
with an exists or some way to get better performance?
select code, id, name, date_of_service
from tbl
where date_of_service in
(select date_of_service
from tbl
where xxx = '29800'
On Thu, 18 Sep 2003 13:23:37 +0800, Christopher Kings-Lynne
snip
To the original poster: You did not provide a lot of information, but
the following suggestions might give you an idea ...
snip
Yes, sorry about that. But in my query for a set of dates returned from the subquery
I would then
To: LN Cisneros [EMAIL PROTECTED], LN Cisneros [EMAIL PROTECTED],
Manfred Koizar [EMAIL PROTECTED],
Christopher Kings-Lynne [EMAIL PROTECTED]
Cc: LN Cisneros [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PERFORM] rewrite in to exists?
Laurette,
SELECT t1.code, t1.id, t1