| From: | Maarten Boekhold <boekhold(at)tibco(dot)com> |
|---|---|
| To: | David Warnock <david(at)sundayta(dot)co(dot)uk> |
| Cc: | Leon <leon(at)udmnet(dot)ru>, pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | Re: [GENERAL] Joins and links |
| Date: | 1999-07-05 15:37:56 |
| Message-ID: | 3780D154.E0C92853@tibco.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)tibco(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Warnock | 1999-07-05 15:56:22 | Re: [GENERAL] Joins and links |
| Previous Message | Ross J. Reedstrom | 1999-07-05 15:16:02 | Re: [GENERAL] GROUP BY problem with 6.5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Warnock | 1999-07-05 15:56:22 | Re: [GENERAL] Joins and links |
| Previous Message | Leon | 1999-07-05 15:24:52 | Fwd: Joins and links |