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 ?
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?
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l