Subject Re: [ib-support] Question on delete
Author Svein Erling Tysvaer
you could try

delete from mytable
where exists(select 1 from listtable where =

Though Arno recently replied that this in theory should be the same as what
you are currently using.

Report back to us your result,

At 16:36 20.03.2003 +0100, you wrote:
>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 ?