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



Rick,

Are there lots of indexes/logical files? The SQE may time out and not
look at every possible index.

Are there Select/Omit logicals? What's the QAQQINI setting for
IGNORE_DERIVED_INDEXES?

Charles

On Mon, Sep 14, 2009 at 10:17 AM, <Rick.Chevalier@xxxxxxxxxxxxxxx> wrote:
Last week I created seven indexes over one of our tables that were advised by the index advisor.  I got the information from system table SYSIXADV and built the indexes with the key columns advised and installed them to production Friday 9/12.  Querying SYSIXADV this morning it shows a last advised date of Saturday 9/13.  I have compared the advised key columns and they match exactly to the indexes I installed on Friday.  The indexes were created with SQL so the advisor should be happy about that.

I don't have access to the query because it originates outside of the iSeries from our data warehouse group.  The same query is run every night.  The index is requested for record selection.  I know there is no guarantee that the optimizer will use the index.  I am wondering what would cause the system to keep advising these indexes when they already exist?


Rick Chevalier
IT Software Solutions - Loan Servicing
[http://www.americredit.com/images/acf_email_sig.gif]
817-525-7178 (w)
rick.chevalier@xxxxxxxxxxxxxxx<mailto:rick.chevalier@xxxxxxxxxxxxxxx>



________________________________
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,
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.