Dear all,

In most transaction tables, there's usually a TRANS_DATE column/field
containing the date of the transaction (duh! :). Usually i create an
ASCENDING index on this field and leave it at that.

But on some scenarios, we'd like to list the transactions in a
descending order (i.e. newest one first). Will it be a good idea to
create a DESCENDING index on the column ? Is there any pitfalls that i
should be aware of ? Will this help performance or confuse the optimizer?

Thanks in advance.