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