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