> -----Ursprüngliche Nachricht-----
> Von: Mauricio I Magni [mailto:mmagni@...]
> Gesendet: Mittwoch, 1. Dezember 2004 23:23
> An: firebird-support@yahoogroups.com
> Betreff: RE: [firebird-support] select in (subquery)
>
>
> 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.
>

OK, updating is another story. Any TRIGGERs which could make the update slow? Any CHECK-constraints without indices? Anything else which gets active while updating? Show us the full UPDATE statement, and for completeness the table definition. Porting an UPDATE to SELECT and then moaning it is not fast enough, is not very representative. I dont need to tell you, that writting will be in any case much slower than reading...

Regards, Alex