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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: MView... Fresh build is much faster than Complete refresh...

Re: MView... Fresh build is much faster than Complete refresh...

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 22 Aug 2007 06:44:38 -0700
Message-ID: <bf46380708220644p671b4a8bxfa8d1332acb7cec1@mail.gmail.com>


On 8/21/07, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
>
> So I have this materialized view. When I execute the create materialized
> view command, it takes 32.39 seconds to build. A complete refresh (exec
> dbms_mview.refresh('mview_name','C'); ) from the prompt this takes almost
> 3-4 times longer. Does anyone have any thoughts on why this might be so just
> right off hand. I've not run a 10046 on it yet, but I thought maybe there
> is something about MVIEW Full Refreshes that I'm just missing.
>
>

10g, right?

Try using atomic_refresh:

Here's an example from a thread here a few months ago:

begin

The default refresh in 10g changed to delete/insert.

In 9i it was truncate/insert append.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2007 - 08:44:38 CDT

Original text of this message

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