MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » October 2013

RE: Stored Procedure Speed/Visual Explain



fixed

Sounds right but I've seen some discussion around that detail,
and I'm no expert.
I would definitely experiment by creating more index/lf to see if
there is a sweet spot.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Thursday, October 17, 2013 1:20 PM
To: Midrange Systems Technical Discussion
Subject: Re: Stored Procedure Speed/Visual Explain

Thanks Gary...I'll do that next. I think some/most of the logicals may have select/omit criteria, and I think that disallows them from consideration.
Right?


On Thu, Oct 17, 2013 at 2:50 PM, Gary Thompson <gthompson@xxxxxxxxxxx>wrote:

Michael,
If nothing from the Advisor, have you at least checked all Where
clauses in your SP for a match or near match to existing index/LF ?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Michael Ryan
Sent: Thursday, October 17, 2013 12:31 PM
To: Midrange Systems Technical Discussion
Subject: Stored Procedure Speed/Visual Explain

Visual Explain/index Advisor woes. I have a stored procedure that
calls an RPG procedure that returns a result set. All is well. But
it's slow. So I take the stored procedure call, put it into
Navigator->Run SQL Scripts, highlight the statement, click Visual
Explain, get a chart of objects used in the query, click
Actions->Advisor, and no indexes are suggested. This query can take a
long time to run - 50+ seconds first time, 30+ seconds after that.

How can I get more information regarding the indexes used or needed?

Thanks!
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact