Subject indexes are one way streets (was: RE: [ib-support] Speed on selec t with order by ......)
Author Michael Weissenbacher
> Indexes are one way streets, and ascending by default. If you need a
> descending index you will need to specifically declare it.

i have some question about this "one-way" streets:
what do i do if for example i want to order persons by their first name
ascending and by their birthday descending. if i want to create a
multi-column index for this it can't be ascending and also not descending.
if i create single indexes on both rows, one asc and one desc i will
increase the number of duplicates. so what is the best way to achive
something like this?

michael weissenbacher