On AS/400, Data are stored in physical files (PF). A physical file can have one index.
Logical Files (LF) are based on Physical Files.
They point to PF data, they can point to multiple physical files (Multi
formats, Join files)
LF can have record selections and omissions.
They can have column selections or expressions.
They can be an access path (Index) to the data.