Re: Functions and Relations
From: Aloha Kakuikanu <aloha.kakuikanu_at_yahoo.com>
Date: 22 Nov 2006 11:25:24 -0800
Message-ID: <1164223524.734289.3270_at_m7g2000cwm.googlegroups.com>
Date: 22 Nov 2006 11:25:24 -0800
Message-ID: <1164223524.734289.3270_at_m7g2000cwm.googlegroups.com>
Aloha Kakuikanu wrote:
> Next, there goes the problem of linear join order. Consider
>
> `x=1` /\ R1(x,z) /\ `y=1` /\ R2(y,z)
One more argument. What if `x=1` and `y=1` are "genuine" relations? Then, what, this bushy plan is out of the search space by the whim of optimizer folks who put a (rather artificial) boundary between relations and predicates? Received on Wed Nov 22 2006 - 20:25:24 CET