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: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 22 Aug 2007 23:13:13 +0300
Message-ID: <6e49b6d00708221313s14728622vde3d39cfed65115@mail.gmail.com>


2007/8/22, Kerber, Andrew W. <Andrew.Kerber_at_umb.com>:
>
>
>
> I have spent a lot of time looking at materialized views, and (apologies to
> Oracle), in my experience they are really only useful if you can/have to do
> incremental refreshes. A create table as select is much faster if you do a
> complete refresh.

I'd say that truncate + insert /*+ append */ as it was in 9i and can be achieved also in 10g is good enough :) And there is one big advantage - query rewrite ...

Gints Plivna
http://www.gplivna.eu

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2007 - 15:13:13 CDT

Original text of this message

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