>>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.
Thanks, Trey. Yes, the usage for this index is always in descending order. I leave the logic, as it is.
If it's not broken, fix it until it is.
My Blog