RE: server is joining remote tables locally
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: aleon68@xxxxxxxxx
- Date: Thu, 10 Mar 2005 15:42:06 -0500
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@remote
Where a.col1 = v.col2
/
Will perform much better.
Tom
-----Original Message-----
From: Scott Hutchinson [mailto:scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx]
Sent: Thursday, March 10, 2005 3:35 PM
To: aleon68@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: server is joining remote tables locally
Alfonso,
Have you tried to DRIVING_SITE hint?
select /*+ DRIVING_SITE(b) */ *=20
from a, b@site1 b c@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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Alfonso Le=F3n
Sent: 10 March 2005 20:26
To: davewendelken@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote:
>=20
> I would try this to see if you get a quick fix:
>=20
> select *
> from a
> ,(select * from b@site1 b, c@site1 c
> where b.col3 =3D c.col4
> ) bc
> where a.col1 =3D bc.col2
>=20
> >select *
> >from a, b@site1 b c@site1 c
> >where a.col1=3Db.col2 and
> >b.col3 =3D c.col4
> >
>=20
> That might cause the join in the remote database.
>=20
> --
> //www.freelists.org/webpage/oracle-l
>=20
--=20
Alfonso Leon
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
