I have a query in a program in which is having col1+col2 > 0 in the where clause. I am converting it to WHERE col1 > col2 * -1. Its giving me some performance gain.
col1 + col2 > 0 is a Stage 2 Predicate. Can ua please let me know the reason for the CPU gain. is col1 > col2 * -1 Stage 1 ? Converting from Stage 2 to Stage 1 is giving the gain ?
Another thing... Can u please share with me any further SQL tuning tips ? We are working on a performance tuning project using COBOL-CICS-DB2.