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

Scott Forstie and Andrew Sloma

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, IBM i
ArticleID=174846
ArticleTitle=Score optimization goals with SQL performance on DB2 for i5/OS
publish-date=11162006