Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Performance on SQL which is using linked objects

Performance on SQL which is using linked objects

From: PL.V. Kathiresan <plv_at_pacific.net.sg>
Date: Thu, 03 Feb 2000 17:50:12 +0800
Message-ID: <38994F53.A32D9D62@pacific.net.sg> 





Hi:



I've an SQL which is using objects from two instances,
through the DB link.  When I select the values separately
from the different instance's objects, it is very fast
in retrieving the data (as per the plan).  But it is
very slow when the objects and the conditions are combined.



What could be the problem ?



Kathiresan
Received on Thu Feb 03 2000 - 03:50:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US