db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Reda134 <reda...@gmail.com>
Subject Derby optimizer for Table Function
Date Wed, 12 Nov 2008 09:15:14 GMT

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.


Mime
View raw message