Re: MView... Fresh build is much faster than Complete refresh...
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: robertgfreeman@xxxxxxxxx
- Date: Wed, 22 Aug 2007 10:06:36 +0300
Assuming 10g (btw where is version? :) complete refresh means delete
and normal insert. So it _might_ be slower than simple create MV. We
had on this list discussion a while ago about it here
//www.freelists.org/archives/oracle-l/01-2007/msg00666.html
and here
//www.freelists.org/archives/oracle-l/06-2007/msg00347.html
Gints Plivna
http://www.gplivna.eu
2007/8/22, Robert Freeman <robertgfreeman@xxxxxxxxx>:
>
> 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.
>
> RF
>
>
> Robert G. Freeman
> Oracle Consultant/DBA/Author
> Principal Engineer/Team Manager
> The Church of Jesus Christ of Latter-Day Saints
> Father of Five, Husband of One,
> Author of various geeky computer titles
> from Osborne/McGraw Hill (Oracle Press)
> Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
> BLOG: http://robertgfreeman.blogspot.com/
> Sig V1.2
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
