Subject RE: [ib-support] Question on delete
Author Louis Kleiman
I have used techniques like adding other WHERE phrases to solve this type of
problem in the past. In you situation, assuming all the ID values are > 0,
I would write the query as follows:

delete from mytable

where ( > 0)

and ( in ( select id from listtable where <search condition> ))


Louis Kleiman


-----Original Message-----
From: Paolo Fainelli [mailto:paolo@...]
Sent: Thursday, March 20, 2003 10:37 AM
Subject: [ib-support] Question on delete

I have a query like this:

delete from mytable where in ( select id from listtable where
<search condition> )

Usually this query delete only few record from a large table. It works, but
slowly, because FB doesn't use the index on

How can I spedd up this query ?

Thanks in advance


Yahoo! Groups Sponsor



To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo!
<> Terms of Service.

[Non-text portions of this message have been removed]