Subject Re: PLAN
--- In ib-support@y..., "Nico Callewaert" <ncw@c...> wrote:
> Hi,
> I've created a query that is making a SUM of some records.
I've checked
> the PLAN and I noticed that it is using NATURAL sort order. I
guess that
> is normal for aggregate functions ? Is it better to avoid using
SUM then ?
> Performance ?
> Thanks a lot,
> Nico Callewaert

Hi, Nico. Aggregate or not means nearly nothing for query plan. Plan
is build on join conditions and where clause having in optimizer's
mind (or your, if you explicitly plan your query) existing indexes.
Look at

Best regards.