--- 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 http://www.ibphoenix.com/ibp_quep.html

Best regards.