The matter of index maintenance is a real one. It does take longer to
update when you add another index to a PF. So it is a classic
tradeoff. And if possible, they are sharing indexes to the nines.
That minimizes the access path update issue.
Indexes are never a problem because the AS/400 automatically shares the
index of an existing file, even a partial index. The only issue I have
seen is that it will not share the index if one is the old type index
and the other is the new terabyte indexes.
Normally when you are creating a field select logical, it is only used
to bring in the fields the program needs. The index is usually already
This thread ...
RE: Are we insane? Unique use of native DB2, (continued)
This mailing list archive is Copyright 1997-2019 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