Indexes and sort order

[Scott]

When setting an Index for a particular field, you have the
option to set the sort order by ascending or descending.
Is there any reason other than preference of data
presentation to sort by descending as opposed to
ascending? Or does the sort order in any way effect the
efficiency of the Index?

 

[Pat Hartman]

The index order is immaterial. Use whatever is most appropriate. Date
fields are usually sorted as descending so that the newest entries are at
the top of the list. Index searches are binary so they are not affected by
row order.