Optimizing ORDER BY with indexes?

From: Dirk Lutzebaeck <lutzeb(at)aeccom(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Optimizing ORDER BY with indexes?
Date: 2000-01-14 08:41:51
Message-ID: 14462.57679.783969.863812@ampato.aeccom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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?

Dirk

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dirk Lutzebaeck 2000-01-14 09:31:40 Re: [SQL] Optimizing ORDER BY with indexes?
Previous Message Michael McCarthy 2000-01-14 08:09:48 key set delete query