top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What's the difference between materialized and dynamic view?

+1 vote
711 views
What's the difference between materialized and dynamic view?
posted Nov 16, 2015 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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.

answer Nov 17, 2015 by Shivaranjini
...