Re: Stored Procedure Speed/Visual Explain

Maybe it doesn't need/use any?

You have it call an RPG program. Perhaps your RPG program does RLA
instead of SQL and that is just not going to get the index advisor's
interest.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Michael Ryan <michaelrtr@xxxxxxxxx>
To: Midrange Systems Technical Discussion <MIDRANGE-l@xxxxxxxxxxxx>,
Date: 10/17/2013 02:31 PM
Subject: Stored Procedure Speed/Visual Explain
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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.