|
Bob Entwistle wrote: > > When we started out on the AS400 11 years ago, a decision was made to always >use > logical files and never use physical keys (index) on all of our files. At >this > point, this is being reevaluated and no one seems to remember why physical >keys > were seen as a bad thing. > > Anyone able to give a short synopsis of the tradeoffs between the two? Any > downsides to using physical keys or indexes? This seems to come up every few years and I have seen decent arguments in both directions but nobody seems to have the final answer. I have used physical keys for many years with no apparent loss of anything. I have used logicals "only" in a few cases and I really don't see any difference. +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
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.