Difference between views and materialized views?
- 5 Answers
- 21230 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / naresh
View: - it is logical table,it doesn't contain any data,it's contain only select statement.
if you modify the data in view,it's immediately effect to the Base table.
it gets rowids same as the base table.
Materialized view: - M.V are mostly use in Data Marts.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why truncate is used in sql?
how to create a new view in mysql? : Sql dba
How do you truncate?
What is full join in sql?
How can we solve sql error: ora-00904: invalid identifier?
Why function is used in sql?
What are conditional predicates?
What are the most important ddl statements in sql?
What is database sql?
What is rtm stands for?
What is pivot query?
what are enums used for in mysql? : Sql dba
what is sql? : Sql dba
Describe different types of general function used in sql?
Why primary key is required?
