Re: Help with SQL

[Vinay Gavankar <vinaygav@xxxxxxxxx>]

I just ran Charles' version on production. My first table had about a 1100
records and the second table about 19.8 billion. I got the result in under
30 minutes.
I may run Birgitta's version over the weekend just for the heck of it :)

On Fri, Jan 17, 2020 at 1:45 PM Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

> It's not really interactive vs batch...
>
> It's OPTIMIZE = *FIRSTIO vs OPTIMIZE = *ALLIO
>
> STRSQL and Run SQL Scripts default to *FIRSTIO, embedded SQL defaults to
> *ALLIO
>
> But either can be changed.
>
> Charles
>
> On Fri, Jan 17, 2020 at 11:42 AM Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
> wrote:
>
> > This is also true - generally speaking interactive will try for faster
> > response, so it gets the first records. Batch tends to go for all.
> >
> > The only situation that is truly interactive, IMO, is a display session.
> > Running statements in remote connections will tend toward the batch
> > approach.
> >
> > Vern
> >
> > On 1/17/2020 12:24 PM, Sam_L wrote:
> > > Digging into my memory, seems to me that the optimizer may decide
> > > differently on batch vs interactive execution. but it's been a while...
> > >
> > > Sam
> > >
> > > On 1/17/2020 11:49 AM, Vernon Hamberg wrote:
> > > > I agree with using Visual Explain - it would show any difference in
> > > > what the optimizer does.
> > > >
> > > > Of course, when the environment changes, the optimizer might make
> > > > different choices.
> >
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com