Customize the optimizer methods for table functions

Customize the optimizer methods for table functions Functionstable function cost Optimizertable function cost

The optimizer makes hard-coded guesses about how to calculate the cost of a user-written Derby-style table function. For this reason, the optimizer may place a table function in an inefficient position in the join order. You can give the optimizer more information so that it makes better choices. See "Programming Derby-style table functions" in the .