MVSFORUMS.com

[JOHNCWL]

Hi,

I have a SQL as below

DECLARE TEST1 CURSOR FOR SELECT CUSTID,CUSTTYPE,LASTPDT FROM TABLE1 WHERE CUSTID>=:H AND CUSTID<:H FOR FETCH ONLY OPTIMIZE FOR 1 ROW


How will >= and < with respect to Range or BETWEEN clause affect??

Does the performance improves if we use IN BETWEEN clause?

Thanks in Advance
John

[kolusu]

Johncwl,

Why don't you run explain for both the statements and then find out which is efficient?

Check this topic ( the last post by me) discusses about EXPLAIN

http://www.mvsforums.com/helpboards/viewtopic.php?t=215

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu