At 05:44 PM 10/30/97 -0500, [log in to unmask] wrote:
>John Alleyn-Day writes:
..........................................

>> Superdex
>>  avoids this by creating B-trees on details as well, and I believe that
>>  Omnidex operates similarly.
>
>As to putting an automatic master on every detail item that you would like to
>have a b-tree appear on, Superdex and Omnidex do the equivalent, it's just
>that you don't see them explicitly outlined in the schema. Worse yet, the TPI
>indexes aren't shareable, dataset-to-dataset, in the way that the new
>master-oriented b-tree datasets inherently are.

I haven't used Omnidex, but Superdex constructs their B-tree indexes
directly on ANY field in either a master or a detail.  Either way could be
advantageous, depending on exactly how your database needed to be accessed.

John D. Alleyn-Day
Alleyn-Day International
408-286-6421   408-286-6474 (Fax)
[log in to unmask]       http://www.Alleyn-Day.com