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

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.

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman
Sent: Wednesday, August 22, 2007 9:12 AM
To: oracle-l
Subject: RE: MView... Fresh build is much faster than Complete
refresh...

 

Thanks everyone, by the way, for all the feedback!! How I missed MVIEW
Refreshes changing from Truncate to delete/insert in 10g I'll never
know!!! I also appreciate Jared pulling out the old thread! Gotta do
better on my research next time.

 

The atomic refresh took the refresh down to 51 seconds pretty reliably.
Still about a 20 second difference, but better than what it was by
far!!! I'm also going to setup a refresh group and see how long it takes
(and make sure that 10g still is doing merges!!)


Does anyone know if this change to not use truncate was in 10gr2 or
10gr2?

 

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 

         


------------------------------------------------------------------------------
NOTICE:  This electronic mail message and any attached files are confidential.  
The information is exclusively for the use of the individual or entity intended 
as the recipient.  If you are not the intended recipient, any use, copying, 
printing, reviewing, retention, disclosure, distribution or forwarding of the 
message or any attached file is not authorized and is strictly prohibited.  If 
you have received this electronic mail message in error, please advise the 
sender by reply electronic mail immediately and permanently delete the original 
transmission, any attachments and any copies of this message from your computer 
system. Thank you.

==============================================================================

Other related posts: