Hi all, The Derby devoloppers mentions in the documentation of table functions, that the optimizer takes 2 Assumtions :
1 - It Assumes by default that table functions are repeatable and thus place them in the inner slot of a join. 2 - It Assumes by default that table functions are expensice and thus place them in the outer slot of a join. Is this not paradoxal ?? Or i get it wrong ?? Thank you for your replies Reda -- View this message in context: http://www.nabble.com/Derby-optimizer-for-Table-Function-tp20456636p20456636.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
