Re: [SQL] Optimizing ORDER BY with indexes?

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] Optimizing ORDER BY with indexes?
Date: 2000-01-14 09:31:40
Message-ID: 14462.60668.225811.469623@ampato.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dirk Lutzebaeck writes:
>
> I'm forced to used ORDER BY on large tables which then takes quite
> long. Is there a chance to create/optimize an index for ORDER BY?
> Or could I write an index method on my own? How would it look like?
>
> Are there any other possiblities to speed up ORDER BY?

Reading about indexes in the Bowman SQL book I think a
_clustered index_ is needed for the problem above.
Does Postgresql support these?

Dirk

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dirk Lutzebaeck 2000-01-14 09:34:54 Re: [SQL] Optimizing ORDER BY with indexes?
Previous Message Dirk Lutzebaeck 2000-01-14 08:41:51 Optimizing ORDER BY with indexes?