Hi Daniel,

>Try this:
>delete from A
> where exist(select 1 from B
> where (TYP = 3) and (PARENTID = 51) and

(B.AID=A.AID))

no change here. The same plan is used:

PLAN (B INDEX (IX_B_TYP)) PLAN (A NATURAL)

>statement that you are trying, but it would most likely require some
>changes in Firebird's engine.

Well, that's to much for me, since as Delphi programmer I don't have a
good "relationship" with C++...

cu Christian