Re: Database link performance

From: Ross Mohan <nonspam_rmohan_at_ix.netcom.com>
Date: Mon, 26 Oct 1998 20:38:51 -0500
Message-ID: <71385n$em@sjx-ixn3.ix.netcom.com>

Mostly you want to avoid doing JOINs over the link. You can force a join to occur
on one db or the other by creating appropriate views there. That way, JOIN rows are
not shuttled across the network, just the result set.

Optimally, you do the join on the faster database.

73353.603_at_compuserve.com <73353.603_at_compuserve.com> wrote in message <712rp1$37t$1_at_nnrp1.dejanews.com>...
>Hello -
>
> I have a need to access data in a table that resides in a one database
>while at the same time accessing data in my primary database. I have it
set
>up right now as a view across a db link, which functions okay, but does not
Received on Mon Oct 26 1998 - 19:38:51 CST