Q

BETWEEN clause -- faster or slower SQL Performance?

My experienced mainframe DB2 colleagues have warned me that coding the predicate "WHERE part_no IS BETWEEN :foo AND :bar" is less efficient than "WHERE part_no >= :foo AND <= :bar"

Is there truly a performance difference?

With DB2 UDB for iSeries there is no performance difference between the BETWEEN predicate and its logic equivalent.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2 

Search400.com's targeted search engine: Get relevant information on DB2/400. 

The Best Web Links: Tips, tutorials and more.

This was first published in June 2005

Dig deeper on DB2 UDB (universal databases)

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close