Page History
...
- Range of values is 0 to 999.
- A value can only be entered if the access route relationship is one to many, i.e. the 3.5.7 Maximum Records is set to One.
Tips & Techniques
- This is a very useful feature when using Predetermined Join Columns to retrieve values from small frequently used code tables to reduce I/Os.
- By storing values in memory, table accesses can be reduced and performance is improved. If more than the keep last value are retrieved, then a table access is simply performed and the current values are overwritten starting from the first value retrieved.
...
Predetermined Join Column Development in the Developer Guide.