Re: Local and Remote queries

??,

You are correct that the remote table data is pulled into the local db to then do the where condition in the join. This could be an issue if the amount of data is large, however a simple workaround is:

Create a view on the remote db, which selects from the remote table, based upon the subset of data you need, then use the view to join in your query, this still returns the data accross the network, however the volume could be less.
Another method is to create a simple snapshot of the remote table in the local database.

Hope this helps,

Vikram.

--
Vikram Goel                                 Motorola email: vgoel_at_pts.mot.com
Oracle DBA - Consultant
Aerotek Inc.                                My email:  vgoel_at_emi.net

Motorola Info:
Mail Stop 39, Room S1014
1500 Gateway Blvd,
Boynton Beach, FL 33426 

In article <4fvo97$rb4_at_athos.cc.bellcore.com>, dmarcus_at_notes.cc.bellcore.com (David Marcus) writes:


>Has anyone had any experience with remote tables joined to a local 

>table(s).  

>eg:  tablea local

>     tableb remote

>

>select ...


>  from tablea a,

>       tableb b

> where a=b;

>

>This gives us very poor performance. I've logged TARs in the past, and was 

>told by Oracle that the entire remote table is brought back into local memory. 

> Can anyone verify this and/or suggest a method around it???  We are 

>running 7.1.3.2 on a HP with oracle financials and peoplesoft along with 

>some home grown apps.  Any help would be appreciated.

>