joins across physical servers

From: Mark W. Aurit <maurit_at_world.nad.northrop.com>
Date: Mon, 20 Mar 1995 16:31:20 GMT
Message-ID: <D5qz8C.4J_at_gremlin.nrtc.northrop.com>


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
Received on Mon Mar 20 1995 - 17:31:20 CET

Original text of this message