Score optimization goals with SQL performance on DB2 for i5/OS
Use the new CLI and JDBC optimization goal interfaces to tune SQL performance
From the developerWorks archives
Date archived: January 13, 2017 | First published: November 16, 2006
Understanding and implementing the best SQL query optimization goal can improve many queries' response time greatly. DB2® for i5/OS on V5R4 delivers a new way to control query optimization through several popular dynamic SQL interfaces. This article shows how to implement the new performance tuning enhancement in the CLI. As an added benefit, you have to leverage iSeries Navigator's Performance Monitor feature to analyze any query's optimization goal.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.