-----Message d'origine-----
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 :
<snip>
OS/400 will share all the access paths, even on a partial key.
</snip>

Not sure if I fully understand that. If I have :
LF1 KFLD1, KFLD2
LF2 KFLD2, KFLD3
LF3 KFLD1

I would imagine you mean that LF3 shares with LF1 but LF2 would not share. Is that right?


<snip>
I did some consulting at a company two years ago. Saved some 150gb of storage by just recreating indexes and sharing the indexes.
</snip>
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?



<snip>
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.
</snip>

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 ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].