Re: Using an SQL index over DDS file?

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Loyd

Do you have any select/omit logicals over this PF? There is a setting in 
the QAQQINI file that you can use to ignore S/O logicals (derived key 
indexes). At 6.1 I believe this defaults to *YES - earlier releases have 
it default to *NO, hence, the behavior you see.

This has nothing to do with being DDS-defined, not with there being 
DDS-defined logical files.

HTH
Vern

On 7/27/2010 8:17 AM, Loyd Goodbar wrote:
> Hi Brigitta,
>
> When looking at VE, the final select says Query Engine Used: CQE; and Reason
> SQE was not used: Derived key or select/omit index exists. The query uses
> the new index.
>
> Is it using CQE because the base file is a DDS-defined PF, or because the PF
> also has logical files defined over it as well as SQL indexes?
>
> Thanks,
> Loyd
>
> On Mon, Jul 26, 2010 at 11:40 PM, Birgitta Hauser<Hauser@xxxxxxxxxxxxxxx>wrote:
>
>    
> > Just because I' curious, it is the CQE which executes the query, isn't it?
> >
> > AFAIK in the SQE SELECT DISTINCT and GROUP BY are treated equally, i.e. the
> > base query for SELECT DISTINCT gets rewritten for GROUP BY (or vice versa).
> > In either way before tuning the CQE, try to get the query executed by the
> > SQE and tune after.
> >
> > Mit freundlichen Grüßen / Best regards
> >
> > Birgitta Hauser
> >
> >