Re: Remote Materialized View containing joins

From: Rajeev Prabhakar <rprabha01_at_gmail.com>
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-l
Received on Thu May 21 2009 - 08:09:37 CDT

Original text of this message