SQL-TUNE

Every month, Doctor DB2 processes a performance problem analysis on a DB2 for VSE & VM request.

SELECT * FROM SYSTEXT1 A ,SYSTEXT2 B WHERE TOPIC BETWEEN :VAR1 AND :VAR2 AND A.ITEM=B.ITEM
SELECT * FROM CUSTOMER WHERE NAME BETWEEN :NAME1 AND :NAME2 AND SOCNUMBER BETWEEN :SOC1 AND :SOC2 ORDER BY NAME

This month, the problem concerns the following request :

SELECT * FROM CLIENT WHERE NAME > :NAME1 AND NAME < :NAME2 ORDER BY NAME

EXPLANATION