Subject | Re: [firebird-support] How to index? |
---|---|
Author | Ales Smodis |
Post date | 2004-11-09T14:21:58Z |
On Tue, 9 Nov 2004, Martijn Tonies wrote:
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
> In general (Arno will disagree with me here), I think thatWouldn't it be faster using the index to group together records and
> indices should be used for quick lookups (WHERE <condition>)
> and sorting should be done only via an index if it makes sense.
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