![materialize definition materialize definition](https://i0.wp.com/sqldusty.com/wp-content/uploads/2013/01/image7.png)
![materialize definition materialize definition](https://static.docsity.com/documents_first_pages/2009/07/23/5d7e22e1441652dbec6122e05ed60f4f.png)
In Views the resulting tuples of the query expression is not get storing on the disk only the query expression is stored on the disk. On other hand 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.
![materialize definition materialize definition](https://oracle-base.com/articles/misc/images/materialized-views/materialized-view.png)
Technically View of a table is a logical virtual copy of the table created by “select query” but the result is not stored anywhere in the disk and every time we need to fire the query when we need data, so always we get updated or latest data from original tables. Now on the basis of characteristic and features of the views we can distinguish between Views and Materialized Views.įollowing are the important differences between Views and Materialized Views. As we know that main constituent of any database is its table, in order to make data accessibility custom there is concept of Views in other words we can say that with the help of Views of a table we can restrict any user to access only that data which is supposed to be accessed by him.