From: | David Warnock <david(at)sundayta(dot)co(dot)uk> |
---|---|
To: | Leon <leon(at)udmnet(dot)ru> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Joins and links |
Date: | 1999-07-05 13:57:13 |
Message-ID: | 3780B9B9.33A48132@sundayta.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Leon,
I have a few questions abo8ut what you are proposing.
My background was in non SQL dbms (DataFlex) which supported recnums
which as you pointed out had a number of advantages. However, recnums
also have a significant number of problems. Some features like
replication have significant dificulties. Others such as exporting and
re-loading your data also need special work-arounds.
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.
Regards
Dave
--
David Warnock
Sundayta Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-05 15:10:06 | Re: [GENERAL] Joins and links |
Previous Message | Herouth Maoz | 1999-07-05 13:49:58 | Re: [GENERAL] Joins and links |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-07-05 15:10:06 | Re: [GENERAL] Joins and links |
Previous Message | Thomas Lockhart | 1999-07-05 13:56:42 | [Fwd: sgml tool] |