Subject Question on delete
Author Paolo Fainelli
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