What is the recommendation for "IGNORE_DERIVED_INDEX" in the QAQQINI file?
We are running 8.3 03 of Infor LX on IBM i 7.1.
I noticed that the 6.1 Memo To Users has this:
QAQQINI option changes
In V6R1, the default value for the QAQQINI option for IGNORE_DERIVED_INDEX
has changed from *NO to *YES. The default behavior now runs supported
queries through the SQE even if a select/omit logical file index is
created over any of the tables in the query. In V6R1, the SQE optimizer
supports many types of derived indexes. The usage of the QAQQINI option
for IGNORE_DERIVED_INDEX applies to only select/omit logical file indexes.
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact