× 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.


  1.  Home
  2. MIDRANGE-L
  3. March 2012

RE: Index Advisor

Thanks. Did not know those existed. But looking at those it looks like the REMOVE_INDEXES will actually DROP an index which I do not want to do. I want to delete the rows from SYSIXADV like the "Clear all advised indexes" does

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Tom E Stieger
Sent: Tuesday, March 13, 2012 10:33 AM
To: Midrange Systems Technical Discussion
Subject: RE: Index Advisor

I'm at 7.1, but I believe this was available at 6.1 as well. In the SYSTOOLS library there are a two SQL procedures the deal with the Index advisor; ACT_ON_INDEX_ADVICE and REMOVE_INDEXES. They aren't quite what you are asking for, but they should be able to help with writing what you need.


-Tom Stieger
IT Manager
California Fine Wire



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Tuesday, March 13, 2012 6:07 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Index Advisor

Does anyone know if there is an API for the Index Advisor? I know it is all accessible from Navigator but I am thinking about creating a utility that will read the SYSIXADV table looking for major issues, sending me an alert about the need for an index, then clear the advisor and start the process over. Maybe run this monthly. I have been able to read the SYSIXADV table and find what I consider a major issue and manually clearing the advisor would be OK, just wanted to try and make it fully automated.
--
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.




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.