Page History
...
- Predetermined join columns are very efficient when used to look up descriptions in code tables where the table accessed is a high speed table but overuse of this facility could cause the opposite effect, particularly in DBOPTIMISED functions when the accessed table is not a high speed table.
- As a guide, do not access more than 10 to 15 tables for Predetermined Join Columns.
See Also
...