| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: relational tables and objects
> 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
![]() |
![]() |