Re: [GENERAL] Joins and links

> 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