Hi,

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

Okey, thanks.

Then i give ASC indices a higher priority to use them against DESC indices
with the same selectivity (for retrieval).

Regards,
Arno