Why we use materialized View? or when do i go for an Materialized View

Please Give any scenario (Or) example of its very help full?

Questions by Rakesh057   answers by Rakesh057

Showing Answers 1 - 5 of 5 Answers

venkat Sidda

  • Jul 28th, 2014

Performance of materialized view is greater than View

  Was this answer useful?  Yes

Deepak Subramoniam

  • Aug 3rd, 2014

Folks materialized views are used for the static tables where the updates are very rare.
in materialized the data set will also have referencein the sga which results in a better performance

  Was this answer useful?  Yes


  • Oct 27th, 2014

Materialized view is a good option when changes are in the parent table(Referring table) is rare and also you need to access data regard less of network availability

  Was this answer useful?  Yes


  • May 29th, 2015

Materialized view is an option when we have data coming on a regular fashion in slots like last weeks data that will be used this week and data is too huge to generate at any point of time this is just one of the cases. There are many variation like refreshing data for current changes / repopulate all data any time etc. It holds data and less frequently updated data is good for better performance and use.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions