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

2007/8/22, Kerber, Andrew W. <Andrew.Kerber@xxxxxxx>:
>
>
>
> 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

Other related posts: