Re: Tuning Query w/database link

From: Daniel W. Fink <Daniel.Fink_at_Sun.COM>
Date: Fri, 06 Aug 2004 14:44:22 -0600
Message-id: <4113EDA6.7040902@sun.com>

You might also try your remote access as an inline query. In older versions, this would result in the inline query being passed to remote db and the result set passed back as a single operation, not a series of network trips during a join.
Example (from memory):
select *
from (select * from test_view_at_remotenode where alra_id = 100001) a,

        project_accounting_costs b
where b.source_id = a.alra_id
/

Regards,
Daniel Fink

Igor Neyman wrote:

>>select * from test_view_at_remotenode a,
>>project_accounting_costs b where a.alra_id=b.source_id and
>>b.source_id=100001;
>>
>>
>
>since a.alra_id=b.source_id, could you change your query to:
>
>a.alra_id=100001 (instead of b.source_id=100001), so:
>
>select * from test_view_at_remotenode a,
> project_accounting_costs b
>where a.alra_id=b.source_id
> and a.alra_id=100001;
>
>Igor Neyman, OCP DBA
>ineyman_at_perceptron.com
>
>
>
>
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Aug 06 2004 - 15:40:53 CDT