What is the differnce between view and materialized view
Answer Posted / suresh babu
View:view is a logical table,it don't have own data,the
query which we mentioned after the create view statement
will be compiled and stored in server as a database
object.once we call the view,the compiled query will be
fetch the data from master table.
The DML operations will be reflected in master table or
view suddenly.
Materialized view:The Materialized view required physical
memory space.it will be created from target master
table,which located in some other location.A materialized
view can be created either single mater table or multimater
tables from multiple master sites.the changes which we have
done in master table will reflect in particular interval
time.the materialized view,which created from multiple
master tables,will updated its individual batch files....
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is identity column in sql server?
Does pl sql work in mysql?
How do you pronounce sql?
What is cursor in pl sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
what is the difference between a local and a global temporary table? : Sql dba
what is sql server agent? : Sql dba
What is rownum?
What is difference between function and trigger?
Which nosql database is best?
How do you write a complex sql query?
Are stored procedures compiled?
How do you run a query?
What is orm in sql?
What are aggregate and scalar functions?