Re: Slow refresh mview

From: HoneyMonster <someone_at_someplace.invalid>
Date: Tue, 21 Dec 2010 21:19:40 +0000 (UTC)
Message-ID: <ier5lb$a1c$2_at_news.eternal-september.org>

On Tue, 21 Dec 2010 13:08:19 -0800, Steve Howard wrote:

> On Dec 21, 8:22 am, "bob123" <nom..._at_nowhere.com> wrote:

>> Hi,
>>
>> I have some Mviews for query rewrite
>> it takes 15-20 minutes to create them The refresh takes more than 5
>> hours ...
>>
>> why ?
>> What can I do to speed this ?
>>
>> Oracle 9.2.0.7
>>
>> Thanks in advance

> 
> 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. Received on Tue Dec 21 2010 - 15:19:40 CST