Re: Tuning Query w/database link
- From: "Daniel W. Fink" <Daniel.Fink@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 06 Aug 2004 14:44:22 -0600
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@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@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@remotenode a,
> project_accounting_costs b
>where a.alra_id=b.source_id
> and a.alra_id=100001;
>
>Igor Neyman, OCP DBA
>ineyman@xxxxxxxxxxxxxx
>
>
>
>
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
