IMO, if the index has been created with NO.NULLS, then the <= would require the file to be scanned as there is a possibility of a "" in the data that would not be index'ed.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kevin King Sent: Friday, 30 January 2009 7:18 AM To: [email protected] Subject: Re: [U2][UD] Index for @ID (IBM documentation) Martin, are you sure? I would expect the query optimizer to see the <= and cancel the use of the 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/
