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
Explain what is a field in a database and record in a database?
What are the types of triggers in sql?
What are sql procedures?
What are the types of keys?
What is pivot table in sql?
Can triggers stop a dml statement from executing on a table?
Explain correlated query work?
Does user triggers have entry for trigger with compilation errors?
Which software is used for pl sql programming?
Can a procedure in a package be overloaded?
What are the different datatypes available in PL/SQL?
What is the difference between rename and alias?
How is indexing done in search engines?
discuss about myisam key cache. : Sql dba
how to check myisam tables for errors? : Sql dba