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