This content has been marked as final. Show 3 replies
Materialized view will give performance improvement if the MV matches rollup requirement.
Thanks for the response.
What do you mean by MV matching Rollup requirement? I just want to use the option 'Enable MV with query rewrite'.
My thinking is that MOLAP cube will have all the summarized information stored in the AWM cells. So how a MV helps improving the performance here?
Thanks and Regards,
Adding a rewrite MV does not change the raw performance of a cube. The only reason to add one is if you want to write your SQL queries against the base relational tables and have the database rewrite your queries against the cube. If you are able to query the cube views directly, then there is no particular benefit to a rewrite MV.
Adding a refresh-only MV does have benefits even if your queries use the cube views. A refresh-only MV tracks the staleness of the cube and lets you run 'fast' refreshes, which can be useful if you are only modifiying a handful of rows in your fact table.