Thread: Re: descending index

"Björn Lundin" wrote:
> Can't you use 'order by' with 'asc or desc' ?
> /Björn

Of course. I just wanted to know if there is a diference between using
order by field asc/desc regarding the way indexes are used in plans
when you execute a query. In Firebird when using order by desc it uses
the descending index if available if not then it uses natural scan with
sort descending. Does PostgreSQL use the ascending index both for
asc and desc order by?

Thanks in advance.

--
Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@rdsor.ro

Pirtea Calin wrote:
> "Björn Lundin" wrote:
>
>>Can't you use 'order by' with 'asc or desc' ?
>>/Björn
>>
>
> Of course. I just wanted to know if there is a diference between using
> order by field asc/desc regarding the way indexes are used in plans
> when you execute a query. In Firebird when using order by desc it uses
> the descending index if available if not then it uses natural scan with
> sort descending. Does PostgreSQL use the ascending index both for
> asc and desc order by?
>
> Thanks in advance.
>
Both.

C.