03 10:34 AM
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
On Thu, 18 Sep 2003 13:23:37 +0800, "Christopher Kings-Lynne"
>To the original poster: You did not provide a lot of information, but
>the following suggestions might give you an idea ...
>
Yes, sorry about that. But in my query for a set of dates returned from the subquery
I would then like
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'