This depends on the version of the database on the driving site.
If your driving site runs 8i, ALL of the data will be brought back
and filtered locally. In 9i, the behavior is that single table
access predicates that can be resolved remotely, are resolved
remotely. Oracle 10g uses gridlock method for remote execution.
Just kidding, haven't actually tried with 10.
--
Mladen Gogala
A & E TV Network
Ext. 1216
> -----Original Message-----
> From: Goulet, Dick [mailto:DGoulet_at_vicr.com]
> Sent: Thursday, September 23, 2004 10:53 AM
> To: Mladen.Gogala_at_aetn.com;
> thomas.mercadante_at_labor.state.ny.us; adar76_at_inter.net.il;
> adar76_at_inter.net.il; Oracle-L (E-mail)
> Subject: RE: DB Links
>
>
> Mladen,
>
> My experience is somewhat different from yours. In the
> case of "FROM EMP_at_LINK WHERE EMPNO = 1234" I have found that
> the local database will pass that along to the remote
> database for resolution since there will definelty be one and
> only one row returned. Now "FROM EMP_at_LINK WHERE EMPNO >
> 1234" would also resolve itself on the remote db, but "FROM
> dept a, EMP_at_LINK b WHERE a.empno = b.empno and b.EMPNO >
> 1234" will result in emp becoming a local temp table.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 23 2004 - 09:52:57 CDT
