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






Antonio,
I think the detailed answer from Vernon is relevant, but I would like to
add my 2 cents.
You are under the impression that the optimizer has not used your access
pathes.  It's not true: the optimizer has used them to collect information,
and with this information the conclusion was to not use them to retrieve
the data.
You are also under the impression that using an existing access path to
retrieve the data is always a winning strategy.  In the good ol' days, it
was often the case: the processor was slow (VERY slow), the caches (if any)
small, the main memory, microscopic.
Now, the processors (often a bunch of) are fast (VERY fast), there are
plenty of caches everywhere (at processor, job, system,  pool, IOP, ...
level), the main memory is huge.  The optimizer is also much more
sophisticated, and has access to additional statistics, especially in
V5R2/R3.  In many cases now, the good strategy is a very simple one: BRUTE
FORCE.
The Vernon's suggestion of EVIs is a good one, it is as efficient with AND
as with OR: in most cases, if used, the optimizer derives bitmaps from EVIs
and cross them to find the RRNs of the selected records. Also, an EVI
gather more detailed statistics about the key values. You could also look
at the statistics thru iSeries Navigator.
Bonne réception/Best regards
Richard THEIS
  iSeries Education, France




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.