> Do I need to create two different indexes, one ordered in ascending and the other in descending?

In contrast to desktop databases, you don't need index for ordering
at all. In most cases local sorting on client side will be much faster.

SY, SD.