Re: Remote Materialized View containing joins
- From: Rajeev Prabhakar <rprabha01@xxxxxxxxx>
- To: Roger.Xu@xxxxxxxx
- Date: Thu, 21 May 2009 09:09:37 -0400
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:
