>Hi everybody,
>
>I'm just curios, if there a reason for creating index in descending order (i.e. INDEX ON indexpr TAG tagname DESCENDING)? In our database we have indexes in descending order, therefore we have this field in our Index Dictionary. I've just thought, is it really neccessary?
It depends.
If you ever want to use an index in descending order, you can always use
SET ORDER TO myindex DESCENDING
so there isn't a reason to create the index descending.
However, if the usage of this index is almost always in descending order, then you might as well create the index that way.
Insanity: Doing the same thing over and over and expecting different results.