in Dataware house by
Q:
What is the difference between View and Materialized View?

▼ Show 1 Answer

0 votes
by

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.

Learn More with Madanswer

Related questions

0 votes
asked Oct 20, 2019 in Dataware house by rajeshsharma
...