Categories

Oct 20, 2019 in Dataware house

Q: What is the difference between View and Materialized View?

1 Answer

Oct 20, 2019

A view is nothing but a virtual table which takes the output of the query and it can be used in place of tables.

A materialized view is nothing but an indirect access to the table data by storing the results of a query in a separate schema.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Oct 20, 2019 in Dataware house
Aug 18, 2019 in MVC Language
Oct 7 in Ansible
...