> 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.
>
We have CLUSTER command, but it is something that has to be run manually.
--
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