Re: joins across physical servers

In article <D5qz8C.4J_at_gremlin.nrtc.northrop.com>, maurit_at_world.nad.northrop.com (Mark W. Aurit) says:
>
>We are joining tables across physical servers on our Oracle 6 databases,
>using SQL*NET, i.e.
>select <stuff> from table1 a, table2_at_server2 b,
>where a.column = b.column
>Reponse is pretty hideous, and under explain it appears that
>joins across servers dont make use of indexes.
>Is that true? What are some good ways to optimize performance
>when going across servers?
>
>Thx, Mark
>Northrop Grumman Corp
>--
>Mark Aurit
>Finance Client/Server Systems
>Northrop Grumman Data Systems (West)
>maurit_at_world.nad.northrop.com
Go to Oracle7. The optimiser is SIGNIFICANTLY better at handling distributed joins...

Regards
GAG Received on Tue Mar 21 1995 - 01:37:04 CET