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:34:54
Message-ID: 14462.60862.309797.178045@ampato.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Dirk Lutzebaeck writes:
> 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?

Ok, I'm talking to my self here:

man cluster

RTFM.

Dirk

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-01-14 15:02:33 Re: [SQL] key set delete query
Previous Message Dirk Lutzebaeck 2000-01-14 09:31:40 Re: [SQL] Optimizing ORDER BY with indexes?