Use of "OR" in selection criteria would stop the use of the index, for example:
SELECT file WITH INDEXED.FIELD = "value" OR NON.INDEX.FIELD = "value" Testing with the actual data appears to be the best way of figuring this stuff out. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Saturday, September 08, 2007 4:49 PM To: [email protected] Subject: Re: RE: [U2] Unidata Query Optimizer Documentation I've seen that documentation in chapter 6, but it doesn't specifically address when the query optimizer is going to apply the index, or even what specific criteria would defeat the index (other than NO.INDEX). ------- 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/
