server is joining remote tables locally

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=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
--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 10 2005 - 15:12:47 CST