Re: [GENERAL] Joins and links - Mailing list pgsql-general

From David Warnock
Subject Re: [GENERAL] Joins and links
Date
Msg-id 3780D5A6.794FB6CF@sundayta.co.uk
Whole thread Raw
In response to Joins and links  (Leon <leon@udmnet.ru>)
List pgsql-general
Maarten Boekhold wrote:
>
> David Warnock wrote:
> > A solution I have seen in some sql dbms (eg MS SQL Server) is to be able
> > to choose one index and have the database table sorted by this index.
> > Then you don't need a separate index for that sort-order. It means that
> > almost any index can work like a recnum and avoid looking in both the
> > index and the data. I am trying to remember the name of this feature but
> > cannot at the moment.
>
> CLUSTER ?

Thats the one. Thanks.

Dave

pgsql-general by date:

Previous
From: Maarten Boekhold
Date:
Subject: Re: [GENERAL] Joins and links
Next
From: David Warnock
Date:
Subject: Re: [GENERAL] Joins and links