Re: Remote Materialized View containing joins

Hello Roger,

What does your explain plan show for the following query ;

SELECT s.rowid "sales_rid", t.rowid "times_rid", c.rowid
"customers_rid",c.cust_id, c.cust_last_name, s.amount_sold, s.quantity_sold,
s.time_id
FROM sales@remotedb s, times@remotedb t, customers@remotedb c
WHERE s.cust_id = c.cust_id AND s.time_id = t.time_id;
If your remote tables are comparatively much bigger than the
local tables, you could choose the driving_site hint and let
the remote site be the driving site of your query. As always,
you need to check the explain plan difference.

-Rajeev


On Wed, May 20, 2009 at 12:32 PM, Xu, Roger <Roger.Xu@xxxxxxxx> wrote:

>   I am trying to go with fast refresh but I am not sure the performance
> issue I may face. Any suggestion? (10.2.0.4)
>
>
> Thanks,
>
> Roger Xu
>
>

Other related posts: