Re: [PERFORM] rewrite in to exists?

2003-09-18 Thread LN Cisneros
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

Re: [PERFORM] rewrite in to exists?

2003-09-18 Thread LN Cisneros
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

[PERFORM] rewrite in to exists?

2003-09-17 Thread LN Cisneros
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'