Improve UDF performance with a new flavor of deterministic.
By Kent Milligan
After V5R3 was released, I wrote an article highlighting the use of the NOT FENCED and DETERMINISTIC options to improve the performance of User-Defined Functions (UDFs). Those are still great options to use to boost performance. However, more recently the IBM i 7.2 release extended the possible reach of the Deterministic option with a new flavor known as statement-level deterministic.