RE: Logical Files vs. Physical Keys

[Kmcmann@xxxxxxxxxxxx]

I don't know if this might have been your reason, but way back on the S/36,
we did the same thing, just because changes could be made to alternative
index keys, but not to parent file keys.

> -----Original Message-----
> From: Bob Entwistle [SMTP:bentwist@famousfootwear.com]
> Sent: Wednesday, March 22, 2000 6:16 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      Logical Files vs. Physical Keys
> 
> 
> 
> 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?
> 
> Bob
> 
> 
> 
> 
> 
> +---
> | 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
> +---
+---
| 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
+---