I have Visual Explain. I can't use it on our production system because I can't start a database monitor. I have been trying for at least two years to be able to do that. For example, the development or test loan master table contains 50k records but the same production table contains over four million. I think that's enough to alter the way the analyzer might handle the query.
Anyway, the part I can't find is the 'show last SQL statement' option for jobs. I don't appear to have access to work management from iNav. I do see a plan cache under the database but it is empty.
I have to admit, I don't spend much time in iNav. The occasional Visual Explain and that's all.
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Monday, September 14, 2009 6:02 PM
To: Midrange Systems Technical Discussion
Subject: Re: Advised index not used but still advised
Visual Explain is not part of work management, it's part of the database stuff - you have to have that component installed, and that might not be there yet. There still might be blockage through App Admin, however.
Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.
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