|
Try the _DB2 UDB for iSeries Database Performance and Query Optimization V5R1_ manual. This used to be in an appendix for SQL. In particular, this page on "Optimizer decision-making rules" <http://publib.boulder.ibm.com/html/as400/v5r1/ic2924/ind ex.htm?info/rzajq/rzajqmst35.htm> covers this. > > >The search order on access paths is from > >most recently created to oldest. > > I couldn't find where this was documented. Is this from experience or have > IBM tucked this tidbit away in a Redbook somewhere? > --buck
As an Amazon Associate we earn from qualifying purchases.
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.