So, Ray, where do I find these rules? Are they written down somewhere that I can get to and acquire a copy?
Jef. ----- Partial Original Message----- No, it's true for all cases. UniVerse indexes are only used on restrictions in the first WITH phrase in the query. That's one of the rules. Indexes are used except: 1. if the NO.INDEX keyword is specified 2. if an active Select List can be used (similar logic to current thread) 3. if the restriction is in other than the first WITH clause 4. if there is an OR conjunction with a non-indexed field 5. if "" will satisfy the restriction (for example a < or <> restriction) and the index is NO.NULLS 6. if the restriction on an indexed field follows a restriction on a non-indexed field in an AND conjunction (this can be re-ordered to get the index used, but is not re-ordered by the query optimizer) An index may also be used if the query is sorted on the indexed field and not constrained. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
