Re: Mview refresh is much slower in 10g
- From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
- To: Smith.Steven@xxxxxxx
- Date: Fri, 19 Jan 2007 00:36:03 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
