Re: Logical Files vs. Physical Keys

[Pat Barber <mboceanside@xxxxxxxxxxxxxxxx>]

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