Differences between views and materialized views can also be understood in terms of their usages.
Views have a more restrictive behavior towards a base table.
1.It could be used to isolate an application in order to prohibit any change in base table definition.
2.It can be used in order to simplify SQL statements for the user.
3.Views could be used to enhance security by restricting access to a predetermined set of columns and rows
Existence of Materialized Views is transparent to the SQL except when used for query rewrites.
1.Query rewrites are said to improve the performance of SQL execution and are useful in a data warehouse environment.
2.Users can insert, delete and update the data by means of updatable materialized views.
Apart from these differences between views and materialized views, some other important points to keep in mind which further clears the concept of views and materialized views are:
1.Views can be based on each other in addition to operating on base tables. A view can JOIN another view with a table using – GROUP BY or UNION clause.
2.Materialized views can be defined on a base table, partitioned table or Views whereas indexes are defined on Materialized views.
3.Ultimately a materialized view log is a schema object which records changes to a master table's data so that the materialized view defined on that master table can be refreshed incrementally.
