-none- 2005-03-10 - By -not available-
Will perform much better.
Tom
-- --Original Message-- --
From: Scott Hutchinson [mailto:scott.hutchinson@(protected)]
Sent: Thursday, March 10, 2005 3:35 PM
To: aleon68@(protected)
Cc: oracle-l@(protected)
Subject: RE: server is joining remote tables locally
Alfonso,
Have you tried to DRIVING_SITE hint?
select /*+ DRIVING_SITE(b) */ *=20
from a, b@(protected) b c@(protected) 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@(protected) =
[mailto:oracle-l-bounce@(protected)]
On Behalf Of Alfonso Le=F3n
Sent: 10 March 2005 20:26
To: davewendelken@(protected)
Cc: oracle-l@(protected)
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@(protected) > wrote:
>=20
> I would try this to see if you get a quick fix:
>=20
> select *
> from a
> ,(select * from b@(protected) b, c@(protected) c
> where b.col3 =3D c.col4
> ) bc
> where a.col1 =3D bc.col2
>=20
> >select *
> >from a, b@(protected) b c@(protected) 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
|
|
