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