Re: [SQL] Optimizing ORDER BY with indexes?

> 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?
> 

CLUSTER command.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026