Re: Tuning Query w/database link

From: <Jared.Still_at_radisys.com>
Date: Fri, 6 Aug 2004 14:04:41 -0700
Message-ID: <OF992D72C0.314CF7E0-ON88256EE8.007376C7-88256EE8.0073C9A6@radisys.com>

oracle-l-bounce_at_freelists.org wrote on 08/06/2004 01:44:22 PM:
> 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
> /
>

Given our recent discussions on subqueries and Oracle's apparent freedom to re-arrange them however it sees fit, I'm not too sure you could rely on this.

How about the DRIVING_SITE hint? This could be used to force the optimizer at the remote db to evaluate the query for the tables local to it.

Jared

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 - 16:00:44 CDT