Subject RE: [firebird-support] select in (subquery)
Author Mauricio I Magni
Hello

> If you want a join, why not simply use a join. These "IN" and "EXISTS"
> statements proved several times to be too slow. They are simply fast when
> you don't retrieve too many records, or if they are static.

Yes, you are right. I forgot tell that I'm doing an update, and then I can't
build a join clause. Then I think the best way to limit the query is using
the "where ... in (select ...)".

Mauricio.