Subject Better plan for delete statement
Author Christian Kaufmann

I have a delete statement like this:

delete from A where AID in
(select AID from B where TYP = 3 and PARENTID = 51)

The two tables are in a 1:1 relationship. On table A and B I have a
unique index on AID.

Is there a way, to speed up such a query? In the plan I see, that the
table A is accessed "NATURAL".

cu Christian