Subject Re: [firebird-support] Index Question
Author Ann W. Harrison
At 11:19 AM 1/28/2004, Chris Meelhuysen wrote:

>My questions is this. Should I use descending indexes because I am usually
>querying off the tail end of the data more often or should I use ascending
>indexes because I'm always ordering from oldest to newest or are these issue
>even intertwined. How would the indexes work under these conditions.

It shouldn't matter at all. Access to records is independent of whether
they are at the beginning, middle, or end of the range of values. Ascending
indexes may allow the system to walk the index rather than sorting the
data. Sometimes walking the index is faster, sometimes not.