Difference between View and Materialized view is one of the popular SQL
interview question, much like truncate
vs delete,correlated
vs noncorrelated subquery or primary
key vs unique key.This is one of
the classic question which keeps appearing in SQL interview now and then and
you simply can’t afford not to learn about them. Doesn’t matter if you are a
programmer, developer or DBA, this SQL questions is common to all. Views are
concept which not every programmer familiar of, it simply not in the category
of CRUD operation or database
transactions or SELECT query, its little advanced concept for average
programmer. Views allows a level of separation than original table in terms of
access rights but it always fetch updated data. Let’s see What is View in
database, What is materialized View and difference between view and
materialized view in database.
Previous Topic
