Re: server is joining remote tables locally

From: Alfonso León <aleon68_at_gmail.com>
Date: Thu, 10 Mar 2005 16:01:25 -0500
Message-ID: <83a585ac05031013017fe3b902@mail.gmail.com>

thanks David, lex and Scott, it does, but it is not the optimal I=B4m looking for, and I'm sorry, but the example I put it is just simple. Let's use the following example with 4 tables that it is more like what I=B4m doing.

select *
from a, b, c_at_site1 c, d_at_site2 d
where a.col1=3Db.col2 and=20

         b.col3=3Dc.col4 and
         c.col5=3Dd.col6

when I used the driving_site hint the join of c and d was executed at the remote site
but it request individual selects for tables a and b at the local site and not the join between a and b

why doesn=B4t the database join the remote tables, it shouldn't be more eff= icient?

        =20
thanks again

On Thu, 10 Mar 2005 21:39:03 +0100 (CET), Lex de Haan <lex.de.haan_at_naturaljoin.nl> wrote:
> did you try the driving_site hint, to force execution at the other node?

>=20

> cheers,

>=20

> Lex.

>=20


> > Hello oh you great masters of Database:

> >

> > I come to you with a humble question

> >

> > version 9.2.0.6 on hp-ux 11i11

> >

> > I have query like this:

> > select *

> > from a, b_at_site1 b c_at_site1 c

> > where a.col1=3Db.col2 and

> > b.col3 =3D c.col4

> >

> > I supposed that the local database should send to the remote database

> > something like this:

> >

> > select * from b,c

> > where b.col2=3D:1 and

> > b.col3 =3D c.col4

> >

> > but.... nooooooo

> >

> > it sent

> >

> > select * from b

> > where b.col2=3D:1

> >

> > and

> >

> > select * from c

> > where c.col4=3D:1

> >

> > and do the join locally

> >

> > Any ideas about the exposed case?

> >

> >

> > Thanks in advance

> >

> > --

> > Alfonso Leon

> > --

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

>=20
>=20

--=20
Alfonso Leon

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

Received on Thu Mar 10 2005 - 16:04:44 CST