Mac,
After DB2's query re-write and optimization, both should perform equally
well. Be sure to have an index on part_no and current distribution
statistics.
Best regards,
Scott
Scott Hayes
IBM GOLD Consultant
If you haven't LYAO recently, be sure to attend DBI's popular Webinar on
Tuesday August 28th at 10a CDT "A Preview to DBI's Performance Solutions:
How to Become a Performance Hero". It's educational and fun. Register:
https://www.gotomeeting.com/register/345361376
-----Original Message-----
From: MChakravarty
[mailto:db2udbdba-ezmlmshield-x99532065.[Email address protected]
Sent: Thursday, August 23, 2007 4:59 AM
To: LazyDBA Discussion
Subject: Which predicate is faster
Hello All,
In db2 udb v7.2 which of the following predicates is more faster :
where part_no is between 100 and 1000
where part_no>=100 and part_no<=1000
Thanks,
Mac
http://www.rac.co.uk
http://www.rac.co.uk/business
http://www.bsm.co.uk
Any opinions expressed in this e-mail are those of the individual and not
necessarily the company. This e-mail and any attachments are confidential to
RAC and/or BSM and are solely for use by the intended recipient.
If you are not the intended recipient you must not disclose, copy or
distribute its contents to any other person nor use its contents in any way.
If you have received this e-mail in error please forward a copy of this
e-mail to "[Email address protected]
RAC Motoring Services: Registered England 1424399
VAT Reg No. GB 238640945
British School of Motoring Limited: Registered England 291902
VAT Reg No. GB 239505847
RAC Financial Services Limited: Registered England & Wales 5171817
VAT Reg No. GB 238640945
Registered Office(s): 8 Surrey Street, Norwich, NR1 3NG
RAC Motoring Services and RAC Financial Services Limited are authorised and
regulated by the Financial Services Authority, both companies are members of
the Aviva group.
This e-mail and any attachments has been scanned for the presence of
computer viruses. RAC/BSM accept no responsibility for computer viruses once
this e-mail has been transmitted.
DB2 & UDB email list listserv db2-l LazyDBA home page