Indexes and sort order

  • Thread starter Thread starter Scott
  • Start date Start date
S

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?
 
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.
 
Back
Top