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

From Bruce Momjian
Subject Re: [GENERAL] Joins and links
Date
Msg-id 199907051603.MAA04492@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Joins and links  (Maarten Boekhold <boekhold@tibco.com>)
List pgsql-general
>
>
> 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 ?
>

man cluster.

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

pgsql-general by date:

Previous
From: David Warnock
Date:
Subject: Re: [GENERAL] Joins and links
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Joins and links