Subject Re: [firebird-support] Re: UPDATE AND DELETE WITH JOIN
Author Rafael Szuminski
> Select * from Bills
> inner join Accounts on BillAccount = AccountID
> is faster than
> Select * from Bills
> where BillAccount in (select AccountID from Accounts where BillAccount
> = AccountID)

This is one area where FB is quite um well....pathetic when compared
to other db's. Once the subselect returns more then a few thousand
rows, all performance goes to hell. Perhaps instead of adding new
update syntax, it would help to increase the performance of subselect
queries and it would solve two issues?