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




I recently did a little fancy footwork with the QAQQINI file so that I
could temporarily set the IGNORE_DERIVED_INDEX setting to *YES.  This was
necessary to cause IBM's enhanced query engine (SQE) to be used where I had
derived logicals built against a physical file, and I wanted to do some SQE
only functions.  My question is, what if I make this IGNORE_DERIVED_INDEX
*YES permanent.  I was initially afraid of bad query performance, but
through some experiments, it seems rare that the query optimizer ever picks
a "derived index" type logical anyway.

I guess, my more specific question is, under what conditions will the query
optimizer pick a "derived index" since my initial experiments show it not
picking it, despite constructing a logical that should have chosen the
derived index.

The bulk of the offending logicals are DDS built for our BPCS ERP system.
They are often used to control soft-deleted records.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.