|Subject||RE: [firebird-support] Re: Request new feature - better perfomance|
> Try this one:While all of the suggestions are appropriate for an immediate work around, the OP original point is still valid.
> select x.* from (
> select something, anotherthing,
> (select sum(thirdthing) from second b where b.something = a.something)
> from a
> ) x where x.total > 10
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.