What are views?
Views are virtual tables used to limit the tables that we want to display. Views are nothing but the result of an SQL statement that has a name associated with it. Since views are not physically present, they take less space to store.
Materialized views
Materialized views are also the logical virtual copy of data-driven by the select query but the result of the query will get stored in the table or disk.
The main difference between view and materialized view is that view is a virtual table that is not stored in the disk while materialized view is a physical copy of the original database that is stored in the disk.
No comments:
Post a Comment