Why use materialized view instead of a table

If Materialized view contains the actual data and has to be re-created every time the original table data is changed and we intent to refresh the data in the view.
then what is the actual use of materialized view, why can't we create another table by itself by running the same query ?

Questions by rasmitaacharya

Showing Answers 1 - 3 of 3 Answers

doc123

  • Mar 23rd, 2012
 

Materialized view is useful in replication and data warehousing environment where every time data extracting and data loading from another sites,databases. Materialized view also useful for maintaining complex queries because it uses query rewrite feature.

  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