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: vc <boston103_at_hotmail.com>
Date: 22 Nov 2006 08:36:20 -0800
Message-ID: <1164213380.870779.116630@k70g2000cwa.googlegroups.com>

Aloha Kakuikanu wrote:
> vc wrote:

> > Can you make this idea a little bit less vague ?
>
> See the detailed evaluation of 6 join orders in the other thread.

Representing predicates as relations for optimization purposes is an interesting idea that was explored by Chaudhuri in 1989 in the LDL project. He mentions the method drawbacks in his later article "Optimization of queries with user defined predicates". You may be interested in reading it. Received on Wed Nov 22 2006 - 10:36:20 CST

Original text of this message

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