What is the advantage of materialized view in Oracle?

0 views

I dislike this

Related questions

  1. Can view be updated in Oracle?
  2. Can we update a materialized view in Oracle?
  3. What is difference between insert and update in SQL?
  4. Can view be updated?
  5. What is SQL Indexing?
  6. What is the difference between Merge and update in Oracle?
  7. Can we delete data from materialized view?
  8. Why do we create materialized view?
  9. What is difference between Merge and update?
  10. Can we do DML operations on materialized view?

Tags

  1. #refreshed
  2. #using
  3. #table
  4. #aggregate
  5. #materialized
  6. #advantage
  7. #where
  8. #advantages
  9. #indexes
  10. #creating
  11. #whenever
  12. #while
  13. #major
  14. #functions
  15. #compare
  16. #create
  17. #retrieves
  18. #affected