Re: Mview refresh is much slower in 10g

2007/1/19, Smith, Steven K - MSHA <Smith.Steven@xxxxxxx>:


We set up 2 identical materialized views - *_MVW_1 and *_MVW_2

Refresh them on an alternating schedule.  As part of the refresh jobs,
recreate a synonym pointing to the newly refreshed view as the last step and
use that synonym to reference the materialized view.


Except for the synonym part we did exactly the same solution for our
searching. I have even written an article explaining how we did that
in
http://www.gplivna.eu/papers/mat_views_search.htm

Gints Plivna
http://www.gplivna.eu
--
http://www.freelists.org/webpage/oracle-l

Other related posts: