RE: server is joining remote tables locally

From: David Wendelken <davewendelken_at_earthlink.net>
Date: Thu, 10 Mar 2005 15:37:30 -0500
Message-ID: <01cb01c525b0$ff713c10$6401a8c0@davidwendelken>

I would try this to see if you get a quick fix:

select *
from a

    ,(select * from b_at_site1 b, c_at_site1 c

       where b.col3 = c.col4
     ) bc

where a.col1 = bc.col2

>select *
>from a, b_at_site1 b c_at_site1 c
>where a.col1=b.col2 and
>b.col3 = c.col4
>

That might cause the join in the remote database.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 10 2005 - 15:22:41 CST