Application Design and Tuning for Performance › Avoiding Redundant Statements

Avoiding Redundant Statements

The best performing statement is the statement that you never execute. Before you create and issue a statement, ask yourself the following questions:

• Is this statement necessary?
• Have I already read that data before?

One of the major issues with applications today is the quantity of SQL statements issued per transaction. The most expensive task you can perform is to leave your allied address space (DB2 distributed address space for remote queries) to go to the DB2 address spaces for an SQL request. Avoid this practice whenever possible.