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 - 15 of 15 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

pavan

  • 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

Arjun

  • 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