RE: server is joining remote tables locally

And if this doesn't work, create a view on the remote site:

Create or replace view remote_join
Select b.*, c.*
>From b ,c

Where b.col3 = c.col3
/

And then from your local machine:

Select * from a.*, v.*
>From a, v_at_remote

Where a.col1 = v.col2
/

Will perform much better.

Tom

-----Original Message-----
From: Scott Hutchinson [mailto:scott.hutchinson_at_interact-analysis.com] Sent: Thursday, March 10, 2005 3:35 PM
To: aleon68_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: RE: server is joining remote tables locally

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
--
http://www.freelists.org/webpage/oracle-l