Local and Remote queries
From: David Marcus <dmarcus_at_notes.cc.bellcore.com>
Date: 1996/02/15
Message-ID: <4fvo97$rb4_at_athos.cc.bellcore.com>#1/1
Date: 1996/02/15
Message-ID: <4fvo97$rb4_at_athos.cc.bellcore.com>#1/1
Has anyone had any experience with remote tables joined to a local
table(s).
eg: tablea local
tableb remote
select ...
tableb 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
from tablea a,
where a=b;