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: relational tables and objects

Re: relational tables and objects

From: Arkadiy Vertleyb <vertleyb_at_hotmail.com>
Date: 1 Nov 2002 19:57:58 -0800
Message-ID: <2f56064a.0211011957.4b57d1d@posting.google.com>


> Who receives the 'join' message? I mean, if I join A and B do I say
>
> A.join(B)
>
> or
>
> R.join(A,B)
>
> where R is in instance of your relational engine? Or to put the question in
> another way, which object has to decide what algorithm is used?
>
> -- Jan Hidders

We rather have:

R.nested_loop_join(A,B);
R.merge_join(A,B);
etc.

and the user decides which one to call. That means we don't have query optimization at this point, either compile, or runtime. This may become the area of future development.

Arkadiy Received on Fri Nov 01 2002 - 21:57:58 CST

Original text of this message

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