Re: Indexed PF vs. LF performance

[Booth Martin <booth@xxxxxxxxxxxx>]

What might make more of a difference would be to reorganize the PF from 
time to time in the order of the key(s) most often used.

On 7/30/2012 3:19 PM, Tim Adair wrote:
> A colleague asked me about this and I haven't been able to find any
> definitive information.
>
> For RPG (IV, but not ILE) doing CHAINs, SETLLs, and READs - which is faster,
> an indexed PF or a flat PF with an LF defined with the key?  For the sake of
> this question, let's assume we're talking about a single key field.  The
> file is DDS-defined, and must remain that way for now.  And for this example
> we're not interested in rewriting the RPG using SQL.
>
> We're on 7.1.
>
>
> Thoughts please?
>
> TIA.
>
>
> ~TA~