Maximize SQE usage with DDS-created DB2 for i databases

Boost your SQL performance

From the developerWorks archives

Kent Milligan

Date archived: January 13, 2017 | First published: January 14, 2010

Applications utilizing SQL experience the best performance when processed by the DB2® for i SQL Query Engine (SQE). However, your use of SQE may be hampered if your database uses keyed logical files containing select/omit criteria. This article describes how you can use the IGNORE_DERIVED_INDEX query options attribute to maximize the use of the SQL Query Engine with databases that contain keyed logical files.

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=461262
ArticleTitle=Maximize SQE usage with DDS-created DB2 for i databases
publish-date=01142010