Specifying Ascending or Descending Ordering in Indexes

Use the asc and desc keywords after index column names to specify the sorting order for the index keys.

Creating indexes so that columns are in the same order specified in the order by clause of queries eliminates the sorting step during query processing. See Indexing for Performance in Performance and Tuning Guide: Locking.