#sql tuning refresher

DB2- Split Predicates to improve SQL Performance

Best rewriting SQL query methods to improve Query performance. First write Split predicates out if possible: SELECT DEPTNO, DEPTNAME FROM DEPT WHERE (ADMRDEPT = ‘E01′ AND DEPTNAME LIKE ‘BRANCH%’) OR (DEPTNO = ‘D01′ AND DEPTNAME LIKE ‘BRANCH%’) can also be tried as: Second write SELECT DEPTNO, DEPTNAME FROM DEPT WHERE (ADMRDEPT = ‘E01′ OR DEPTNO = ‘D01′) AND DEPTNAME LIKE ‘BRANCH%’ The idea here…