Re: Logical Files vs. Physical Keys

[Vanja Jovic <vanja@xxxxxxxxx>]

System defaults for blocking (where applicable) PF without keys are
different than defaults for blocking PF with keys, so you might see
performance difference (PF without keys would perform better).


Vanja Jovic,
Canada

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