Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: descending index

  • From: CoL <col(at)mportal(dot)hu>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: descending index
  • Date: Thu, 28 Feb 2002 02:13:22 +0100
  • Message-id: <3C7D8432.7060606@mportal.hu> <text/plain>
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.
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group