Subject Index Question
Author Chris Meelhuysen
The software I develop books dates. So I am constantly querying for date
ranges. Obviously the newest dates are going to be queried more often then
older dates as time progresses; however, These queries are always ordered
from oldest to newest.

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.