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 is response to performance problems: Check the organization of the data and the availability and accuracy of the data statistics.