User-defined table function performance improvements
The merge capabilities of user-defined table functions are enhanced in Db2 12 to be similar to the capabilities of views.
Db2 12 also introduces indexes on the join or correlation predicates that are passed in as parameters to user-defined table functions to improve performance.