Subject Re: indexes are one way streets (was: RE: [ib-support] Speed on select with order by ......)
Author Nando Dessena

> 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.

create index myindex on people (first_name, birthday desc)

Not sure about the syntax, but it should be something like that.
I don't think Paul meant that multicolumn indexes cannot have a
direction specified for each segment, when he said that indexes are one
way streets; just that their use in queries must match the directions in
their definitions (unlike what happens with other RDBMSs).