The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact firstname.lastname@example.org.
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,
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!
----- 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.
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.
As an Amazon Associate we earn from qualifying purchases.