Subject Re: [IB-Architect] Optimal function of DESC Index versus ASC Index ?
Author Ann W. Harrison
Post date 2002-11-04T21:01:19Z
At 09:36 PM 11/4/2002 +0100, Arno Brinkman wrote:


>Could someone tell me when an DESC index has a performance against an ASC
>index.
>
>The only things i can see is when a DESC index is used for MAX function and
>ORDER BY.

That's right. Descending indexes may also be useful when
we turn on scrolling cursors.



Regards,

Ann
www.ibphoenix.com
We have answers.