Creating an index in both asc and desc directions
I'd be surprised to hear of a modern database that can't do reverse order index scans.


SQL Server certainly does and the backward scan is indicated in the execution plan.
Firebird (search for backward in the page text).
MySQL