Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: materlized views from complex queries and refresh

Re: materlized views from complex queries and refresh

From: cptkirkh <khill_at_scic.com>
Date: 14 Jan 2007 17:54:31 -0800
Message-ID: <1168826071.585782.27720@11g2000cwr.googlegroups.com>


MY best would be most efficnet with the most current data. We are running 10g
DA Morgan wrote:
> cptkirkh wrote:
> > What is the best way to refresh a MV that is based upon a complex SQL
> > query that joins three tables? I would prefer fast refresh on commit.
> > Thanks for your help.
>
> Define "best" and include your version.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Sun Jan 14 2007 - 19:54:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US