Re: Slow refresh mview

From: bob123 <>
Date: Wed, 22 Dec 2010 09:38:59 +0100
Message-ID: <4d1302e2$1$15976$>

>> In addition to Adrian's comments, in 10g and above you can do a "non-
>> atomic" refresh that truncates the materialized view (rather than
>> deleting the rows) under the covers. This is much faster provided you
>> have your query rewrite stuff set up correctly.
> IIRC 9i would do that too on a full refresh, provided you didn't make the
> snapshot^H^H^H mview part of a group.

OK thanks in 9iR2
What option for atomic_refresh I have to set to get a truncate instead of a delete ?   Received on Wed Dec 22 2010 - 02:38:59 CST

Original text of this message