I am using FB 1.5 and doing a delete from a large table using the
primary key as a reference from a sub select

delete from tableA where ID in (select ID from tableB where someval = 'x')
The subquery is fast and looks like it uses the index. But the plan for
the delete is (ID NATURAL) and take a minute to run.

Other then creating a stored procedure to do this, how can I improve the
query?

--
Thanks,

Gordon