× 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 support@midrange.com.



Vern,

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.

Rick

-----Original Message-----
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

Rick

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.

HTH
Vern


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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.