Re: Script script Run and Explain

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

Thanks to everybody that replied. My pulldown from Visual Explain 
doesn't have an Actions button. There's an Options but no index 
suggestions, unless I misinterpreted something. The program I'm working 
on, I just found out a couple weeks ago, takes an average of about FIVE 
MINUTES from entering the menu option to the first screen. Yikes!

To Birgitta, I've been tweking the syntax in several different ways. 
Based on replies to an earlier question, I'm working on creating a 
permanent SQL View and using that to declare the cursor in the RPG.

But the view has to be complex to simulate the way it's working now. 
Three main users assigned to an account, backup users for the three, 2 
flags to control backing up or no, a special entry that overrides them 
all, a date range to control backups, all this spread out to three 
different files to join. And in the view, accommodate getting all the 
accounts for which the user is first-level backup, another to view any 
other user's accounts for which they are one of the three primary 
assigned users. Whew! And then use that to get the shipments associated 
with those accounts. AND handle about ten different sorts over all that 
data! After I get that done for the "Main List", I'll have to apply this 
to about 12 other programs that get other subsets of the rows!! 
==>THANKS for seeing me vent with this Too Much Information.

I did get a list of suggested indexes with an option clicking on a 
schema. That gave me gobs of suggestions on a lot of files, but from 
that I got a list of the four or five files involved.

Thanks very much to all of you,

--Alan Cassidy


On 5/5/2022 2:54 PM, Vern Hamberg via MIDRANGE-L wrote:
> A right-click on a node in the diagram might also have something about suggestions - I think!
>
> Cheers
> Vern
>
> ----- Original Message -----
> From: "Justin Taylor"<jtaylor.0ab@xxxxxxxxx>
> To: "Midrange Systems Technical Discussion"<midrange-l@xxxxxxxxxxxxxxxxxx>
> Sent: Thursday, May 5, 2022 12:57:50 PM
> Subject: Re: Script script Run and Explain
>
> They would be under Actions=>Index and Statistics Advisor from the menu on
> the Visual Explain window.  There aren't always suggestions.
>
> HTH
>
>
> date: Thu, 5 May 2022 11:13:25 -0400
> > from: Alan Cassidy<cfuture@xxxxxxxxxxx>
> > subject: Script script Run and Explain
> >
> > I've looked around and can't find the answer for this.
> >
> > I have clicked on Run and Explain in the SQL script Visual Explain tab,
> > but I can't find suggestions for indexes to improve performance. I was
> > told it does make suggestions. I ran one complex SQL statement there.
> >
> > --Thanks
> >
> > Alan