DB2 V8 z/OS Difference of BETWEEN and <= and =>

Glen Sanderson

DB2 V8 z/OS Difference of BETWEEN and <= and =>
We are noticing that old dynamic queries that use the <= and => syntax
for a range of values is not using the index with the column. However,
if we change it to BETWEEN it does use the proper index. Has the
optimizer for V8 changed to prefer the BETWEEN syntax? (In prior
versions it favoured the <= and => syntax or treated them the same).


"MMS <safeway.com>" made the following annotations.
------------------------------------------------------------------------------
Warning:
All e-mail sent to this address will be received by the Safeway corporate e-mail system, and is subject to archival and review by someone other than the recipient. This e-mail may contain information proprietary to Safeway and is intended only for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s), you are notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately.

=====

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm