<< If the engine is "smart enough" it may choose not to use the index.
Very often, sorting the result set is faster than following the index.>>

Apparently I can't mix ASC columns with DESC columns in a composite index,
so it's a moot point (for me, in this instance) anyway.

Clay Shannon,
Dimension 4 Software