Re: Slow refresh mview
From: bob123 <nomail_at_nowhere.com>
Date: Wed, 22 Dec 2010 09:26:57 +0100
Message-ID: <4d1302e2$0$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:26:57 +0100
Message-ID: <4d1302e2$0$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
I 9iR2 what atomic_refresh I have to set
to get a truncate instead of a delete ?
Received on Wed Dec 22 2010 - 02:26:57 CST