Re: Script script Run and Explain

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