Isn't that true only when using 'AND' with the 'WITH' phrase? Using 'OR' would have to use the whole index/selection again.
-----Original Message----- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Saturday, October 20, 2007 11:30 PM To: [email protected] Subject: Re: [U2] Indexing & Optimization 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
