Re: Slow refresh mview
From: bob123 <nomail_at_nowhere.com>
Date: Wed, 22 Dec 2010 09:38:59 +0100
Message-ID: <4d1302e2$1$15976$426a34cc_at_news.free.fr>
>> 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.
Date: Wed, 22 Dec 2010 09:38:59 +0100
Message-ID: <4d1302e2$1$15976$426a34cc_at_news.free.fr>
>> 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