Re: server is joining remote tables locally
- From: Alfonso León <aleon68@xxxxxxxxx>
- To: davewendelken@xxxxxxxxxxxxx
- Date: Thu, 10 Mar 2005 15:26:13 -0500
been there, done that, didn't work
On Thu, 10 Mar 2005 15:37:30 -0500, David Wendelken
<davewendelken@xxxxxxxxxxxxx> wrote:
>
> I would try this to see if you get a quick fix:
>
> select *
> from a
> ,(select * from b@site1 b, c@site1 c
> where b.col3 = c.col4
> ) bc
> where a.col1 = bc.col2
>
> >select *
> >from a, b@site1 b c@site1 c
> >where a.col1=b.col2 and
> >b.col3 = c.col4
> >
>
> That might cause the join in the remote database.
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Alfonso Leon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
