MView... Fresh build is much faster than Complete refresh...
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 21 Aug 2007 23:26:26 -0600
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
Other related posts:
