Maximize SQE usage with DDS-created DB2 for i databases
Boost your SQL performance
From the developerWorks archives
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.