Interested to Buy Any Domain ? << Click Here >> for more details...
What is the differnce between view and materialized view
- 4 Answers
- 9326 Views
- TCS, I also Faced
- E-Mail Answers
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 the difference between cluster and non-cluster index?
Explain the update statement in sql
How do you delete a table?
What is a trigger in sql?
What is difference sql and mysql?
What is anonymous block in sql?
What is the advantage of index in sql?
What is pessimistic concurrency control? : Transact sql
What are the advantages of pl sql?
What is sql procedures and functions?
What are dml commands?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
Explain table and field in sql?
What does the sign mean in sql?
