Subject Re: [firebird-support] How to index?
Author Ales Smodis
On Tue, 9 Nov 2004, Martijn Tonies wrote:

> In general (Arno will disagree with me here), I think that
> indices should be used for quick lookups (WHERE <condition>)
> and sorting should be done only via an index if it makes sense.

Wouldn't it be faster using the index to group together records and
do the sum, instead of sorting it and doing the sum? I mean, if
the data is already properly indexed (sorted), why do sorting
anyway? It should be faster, but then again I don't know the
internals.

-Ales