Re: [U2] Indexing & Optimization

[Ray Wurlod]

One of the rules for UniVerse to use an index is that the restriction occurs in 
the first WITH phrase.  The reasoning is that the majority of records to be 
excluded will have been excluded by the first WITH clause, and that therefore 
the second WITH clause need only examine the record selected by the first WITH 
clause.
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/