I got a question regarding the difference between materialized views and tables. As I know, materialized views will store the data with the view, so that next time while running sql against the materialized view, it will not do the query in view again. But is there any differences between materialized views and tables. I can also do the same thing using the table by duplicating the data to the table. Will there be any difference? In that case, I can also safe some time for refreshing the materialized view. Would that be better if the data size is very large and there is frequent insert but not much update?
Thanks in advance for your help.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!