server is joining remote tables locally
- From: Alfonso León <aleon68@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 10 Mar 2005 15:09:20 -0500
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@site1 b c@site1 c
where a.col1=b.col2 and
b.col3 = c.col4
I supposed that the local database should send to the remote database
something like this:
select * from b,c
where b.col2=:1 and
b.col3 = c.col4
but.... nooooooo
it sent
select * from b
where b.col2=:1
and
select * from c
where c.col4=:1
and do the join locally
Any ideas about the exposed case?
Thanks in advance
--
Alfonso Leon
--
//www.freelists.org/webpage/oracle-l
Other related posts:
