Think about index order allows you to create index columns in descending order in addition to creating them in ascending order, the default. Descending indexes provide performance benefits for the kinds of queries that require sorting data in descending order. Descending indexes Index orderperformance implications of

See for some examples.

To ensure performance benefits, verify that the descending index is being used. See for information on how to do this.