| Subject | Re: indexes are one way streets (was: RE: [ib-support] Speed on select with order by ......) |
|---|---|
| Author | Nando Dessena |
| Post date | 2002-08-12T09:14:11Z |
Michael,
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).
Ciao
--
____
_/\/ando
> i have some question about this "one-way" streets:create index myindex on people (first_name, birthday desc)
> 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.
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).
Ciao
--
____
_/\/ando