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.
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.