Re: Authority required for SQL

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Rob is completely right about testing - the optimizer does consider the 
environment when it decides how to process the request. Available memory 
and CPU are certainly looked at.

But if the question is one of authority to a logical, the STRDBG test 
(or VE) might tell you that the LF was not even looked at.

BTW, look into a QAQQINI setting that says to look at ALL indexes when 
optimizing - I think it's there.

Ah, but memory doth leak!

Cheers
Vern

On 5/1/2020 11:54 AM, Joe Pluta wrote:
> Agreed, Rob.  That's why I was hoping for definitive answers from 
> someone who knew.  The SQL optimizer often makes decisions that aren't 
> intuitive to me.
>
> On 5/1/2020 11:41 AM, Rob Berendt wrote:
> > Testing is often valid.  Sometimes it's not.  As there may be rules 
> > in the sql optimizer which may work with test data and a test load 
> > but not production data in a production load.
> >
> > Rob Berendt