I'm a bit like a born again Christian when it comes to materialized views. They've been around for ages and I've never used them... until now. Now I cann't get enough of them and feel the need to convert everybody and everything to use them.
Advantages are:-
With query rewrite enabled the optimizer will use the materialized view if it is quicker and the materialized view is up to date.
Materialized views, used in conjunction with the correct table partitioning and using dbms_mview.pmarker function in the view, will ensure that even a 'FULL' refresh only does the necessary partitions.
There more, much much more which I will write when I get time
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment