Hi

> So, ideally what should be implemented is that self-contained subqueries

like the one above would be executed separately and the engine would only
have to reference the result set, instead of executing the subquery for each
row of the DML. This "could" also improve performance.

And I would bet, the firebird architects already got that idea.
So go ahead, implement it.

Regards,
Steffen


[Non-text portions of this message have been removed]