Re: Remote Materialized View containing joins
Date: Thu, 21 May 2009 09:09:37 -0400
Message-ID: <2ba656800905210609k69a9e1ebp29f3609af36ffb0d_at_mail.gmail.com>
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_at_remotedb s, times_at_remotedb t, customers_at_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_at_dpsg.com> 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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 21 2009 - 08:09:37 CDT