| From: | David Warnock <david(at)sundayta(dot)co(dot)uk> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: [GENERAL] Joins and links |
| Date: | 1999-07-05 15:56:22 |
| Message-ID: | 3780D5A6.794FB6CF@sundayta.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Warnock | 1999-07-05 16:02:36 | Re: [GENERAL] Joins and links |
| Previous Message | Maarten Boekhold | 1999-07-05 15:37:56 | Re: [GENERAL] Joins and links |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Warnock | 1999-07-05 16:02:36 | Re: [GENERAL] Joins and links |
| Previous Message | Maarten Boekhold | 1999-07-05 15:37:56 | Re: [GENERAL] Joins and links |