Would it concern you that a major software house sides with your boss?
http://www-912.ibm.com/n_dir/nas4apar.nsf/c79815e083182fec862564c00079d117/2ed784e875e77a4586257490003c6d39?OpenDocument
********************************************************
SQL Performance
********************************************************
--------------------------------------------------------
Affected BPCS versions: V6.x, V8.x
--------------------------------------------------------
Infor recommends the following QAQQINI file setting to
be activated for support with R610:
QAQQINI IGNORE_DERIVED_INDEX *NO
The BPCS and ERPLX database contains large numbers of
Select/Omit logical files and if this option is not set,
these logical files will be ignored when the SQL Optimzer
selects logical files to run a given query. This can cause
poor performance.
The following command shows how to setup this option...
Rob Berendt
This mailing list archive is Copyright 1997-2026 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
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
