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 -----------------------------------------------------------------