I have a query like this:

delete from mytable where mytable.id 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 mytable.id.

How can I spedd up this query ?

Thanks in advance


Paolo