|
> From: M. Lazarus > > >they changed all of the Access path size from *MAX4G to *MAX1TB in all > >keyed files and logicals files, they were told by IBM to do this because > >the data from some database monitor jobs showed high contention for keys. > > > >What has been your experience with these two issues? > > I know of a shop that did the access path change en masse and > experienced > *terrible* performance degradation. EVI's are only better in certain > circumstances. It is not an across the board panacea. I'm a bit confused here. What's the relationship between *MAX1TB and EVI? I thought EVI (Encoded Vector Index) was a special kind of index and you had to do some magic to enable it. >From what I understand, EVIs are only helpful when the number of used key values is a small number of the possible values. Joe
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.
midrange.com
