Subject RE: [firebird-support] Re: Request new feature - better perfomance
Author Leyne, Sean
> Try this one:
> select x.* from (
>   select something, anotherthing,
>   (select sum(thirdthing) from second b where b.something = a.something)
> total
>   from a
> ) x where > 10

While all of the suggestions are appropriate for an immediate work around, the OP original point is still valid.

Firebird engine should be doing a better job of analyzing queries and looking to reduce the unrequired loop/sub-queries due to duplicate sub-queries.