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