Re: Mview refresh is much slower in 10g

2007/1/19, Smith, Steven K - MSHA <Smith.Steven_at_dol.gov>:
>
> 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