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

From Maarten Boekhold
Subject Re: [GENERAL] Joins and links
Date
Msg-id 3780D154.E0C92853@tibco.com
Whole thread Raw
In response to Joins and links  (Leon <leon@udmnet.ru>)
Responses Re: [GENERAL] Joins and links
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 ?

--

Maarten Boekhold, boekhold@tibco.com
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com

pgsql-general by date:

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