Thread: Indexes to speed sorting

In other DBMSs indexes speed the process of sorting on a field in an
ORDER BY clause if the same conditions for WHERE and JOIN clauses are
met. I didn't see this mentioned in the docs on indexes though. Does
an index also speed sorting as it does lookup in the other clauses?

Jeff Willden

On Jan 26, 2008 11:21 AM, Jeff Willden <jeff@pavanell.com> wrote:
> In other DBMSs indexes speed the process of sorting on a field in an
> ORDER BY clause
>

The upcoming 8.3 will do:
http://www.postgresql.org/docs/8.3/static/indexes-ordering.html


--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook