Usage of Indexes and its Effects on an RPG Program

["Brian Piotrowski" <bpiotrowski@xxxxxxxxxxxxxxx>]

Hi All,

 

I have a physical file that has 20 fields and contains over 2,000,000
records.  In the current RPG program, it does a SETLL/READE on the data
based on a key (which is the first five fields in the record).  However,
the READE command does not have an associated logical file - it is using
the straight PF (this program was written before my time, and I suspect
does not run as efficiently as it should).

 

I went into the system (via Navigator) and added an index to this PF of
the fields that are in the key.  Now my question: when a new index is
created on a physical file, will an RPG program begin using it
automatically, or does the program need to be made aware of the index?

 

Thanks!


Brian.

 

-=-=-=-=-=-=-=-=-=-=-=-=-=-

Brian Piotrowski

Specialist - I.T.

Simcoe Parts Service, Inc.

PH: 705-435-7814

FX: 705-435-6746

-=-=-=-=-=-=-=-=-=-=-=-=-=-