Hi,
I want to fine tune my query to reduce the time of execution. In SQL select statement there is

WHERE CHECK_NO_INTERNAL > :H

We modified by using

WHERE CHECK_NO_INTERNAL BETWEEN :H AND :H. It reduces the time. Is there any other way to optimize this query execution.

Thanks in advance
Shyam

You can try to run more detailed runstats (with distribution) on the table. Without knowing the distribution of values on the table, DB2 assumes that > or < will return more rows than a "between". This can affect whether DB2 chooses to use an index. You can also try to alter the table to set it VOLATILE, which usually encourages DB2 to use an index that might not ordinarily be used.