×
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.
General rule of thumb is do you have an appropriate index? I believe generally an index should start out with the columns in your where clause, then your order by. For example
Select ordernumber
From orderheader
Where ActiveRecordCode='A'
Order by ordernumber;
Would have an index with active record code and order number. One of the reasons that IBM tweaked the logic on an index and allowed stuff to emulate 90% of the logical files found in ERP systems for files like those above.
You may have an entry in this:
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqindexadvisor.htm
Rob Berendt
This mailing list archive is Copyright 1997-2025 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.
midrange.com
