Re: CQE, SQE and QAQQINI

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

If you have a plethora of select/omit logicals, yeah, put it to *NO - if 
you 1 out 30 others on the same table, set it to *YES. In all these 
things, YMMV.

Vern

rob@xxxxxxxxx wrote:
> 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
>