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.