Subject | indexes are one way streets (was: RE: [ib-support] Speed on selec t with order by ......) |
---|---|
Author | Michael Weissenbacher |
Post date | 2002-08-12T09:06:48Z |
> Indexes are one way streets, and ascending by default. If you need ai have some question about this "one-way" streets:
> descending index you will need to specifically declare it.
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?
regards
michael weissenbacher