Writing efficient SQL queries

You might be able to rewrite certain SQL statements to enable more efficient access path selection.

Before you begin

Before rewriting existing SQL statements in response to performance problems, check the organization of the data and the availability and accuracy of the data statistics. Fore more information, see Monitoring catalog statistics.

Tip: You can use tools such as IBM® Data Server Manager and related Db2 Tools for z/OS® solutions to simplify this task.