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

What was interesting too was if I did atomic_refesh=>FALSE (the default) it took 25 seconds LONGER than if I didn't put it in at all. That was weird!! Perhaps something with the code tree that is inefficient??

Atomic_refresh=>true = much faster!!!

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

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Robert Freeman   Sent: Wednesday, August 22, 2007 8: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

--
http://www.freelists.org/webpage/oracle-l