Re: How can I join 2 databases?

Client side joins should be avoided - they are simply too expensive in that all data needs to be sent across the network no matter how many rows actually appear in the final result set. Instead, use a dblink in 1 database so that you can access the data in the other database. On 8.0.5 you will see some optimization of the join across the dblink, and even more so on Oracle8i.

> From: "Ron" <ronyin_at_tpts5.seed.net.tw>
> Organization: DCI HiNet
> Newsgroups: comp.databases.oracle.server
> Date: Thu, 8 Mar 2001 13:18:17 +0800
> Subject: How can I join 2 databases?
>
> i'm using oracle8.0.5 on RS6000?
> how can i join 2 tables from 2 databases by using client applications(VB or
> Java)?
>
> Ron
>
>
Received on Thu Mar 08 2001 - 21:29:25 CST