| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: MView... Fresh build is much faster than Complete refresh...
Do you have false and true backwards in your email below?
According to the 10.2 docs, several Metalink notes, and the notes from Jared and Gints, the default is atomic_refresh=>TRUE, and you have to change it to FALSE to get the faster TRUNCATE & Direct INSERT behavior.
Regards,
Brandon
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Robert Freeman
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!!!
-----Original Message----- From: oracle-l-bounce_at_freelists.org
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!!!
The atomic refresh took the refresh down to 51 seconds pretty reliably.
Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 22 2007 - 15:38:47 CDT
 |
 |