• Home
  • Recent Q&A
  • Java
  • Cloud
  • JavaScript
  • Python
  • SQL
  • PHP
  • HTML
  • C++
  • Data Science
  • DBMS
  • Devops
  • Hadoop
  • Machine Learning
in Dataware house by
Q:
What is the difference between View and Materialized View?

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.

Related questions

0 votes
asked Oct 20, 2019 in Dataware house by rajeshsharma
0 votes
asked Aug 18, 2019 in MVC Language by sheetalkhandelwal
...