Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Functions and Relations

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@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 - 13:25:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US