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. > ----- Original Message ----- > From: "Jerry Banker" <[EMAIL PROTECTED]> > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Indexing & Optimization > Date: Mon, 22 Oct 2007 08:02:37 -0500 > > > Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR' > would have to use the whole index/selection again. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/