RE: server is joining remote tables locally

From: Scott Hutchinson <scott.hutchinson_at_interact-analysis.com>
Date: Thu, 10 Mar 2005 20:34:58 -0000
Message-ID: <003201c525b0$a0a46f90$0100a8c0@INTERACT>

Alfonso,

Have you tried to DRIVING_SITE hint?

select /*+ DRIVING_SITE(b) */ *=20
from a, b_at_site1 b c_at_site1 c
where a.col1=3Db.col2 and
b.col3 =3D c.col4

This will send a copy of "a" across to "site1" then do the joins there.

Scott Hutchinson
Interact Analysis Ltd

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Alfonso Le=F3n
Sent: 10 March 2005 20:26
To: davewendelken_at_earthlink.net
Cc: oracle-l_at_freelists.org
Subject: Re: server is joining remote tables locally

been there, done that, didn't work

On Thu, 10 Mar 2005 15:37:30 -0500, David Wendelken <davewendelken_at_earthlink.net> wrote:
>=20

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

>=20

> select *
> from a
>    ,(select * from b_at_site1 b, c_at_site1 c
>       where b.col3 =3D c.col4
>     ) bc
> where a.col1 =3D bc.col2

>=20

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

>=20

> That might cause the join in the remote database.

>=20

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

>=20

--=20
Alfonso Leon

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

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

Received on Thu Mar 10 2005 - 15:38:28 CST