De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Alan Campin
Envoyé : jeudi 13 mars 2008 18:29
À : midrange-l@xxxxxxxxxxxx
Objet : RE: Are we insane? Unique use of native DB2
Alan Campin :
OS/400 will share all the access paths, even on a partial key.
Not sure if I fully understand that. If I have :
LF1 KFLD1, KFLD2
LF2 KFLD2, KFLD3
I would imagine you mean that LF3 shares with LF1 but LF2 would not share. Is that right?
I did some consulting at a company two years ago. Saved some 150gb of storage by just recreating indexes and sharing the indexes.
In the above example, if I were able to replace LF2 so that it had the same key as LF1, do I reduce the amount of storage needed?
This is really an exercise any shop should do. Check to see if you have indexes that could be recreated and would then share an existing access path.
How would you start such a check? Go through all the applications to see if a common access path could be created?
Thanks to all for a really interesting discussion.
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