Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22466 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / rahul khanke
views : this are the vertiual table.. views dosent stores
the data.. if we update the table then updation is in
actual table..
M view : this are the tables based on one or more tables..
this stores the data.. updation is done then actual
updation is in M. view itself..
| Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
what are the advantages of mysql in comparison to oracle? : Sql dba
What is a common use of group by in sql?
Are dml statements autocommit?
Which is better cte or subquery?
What does count (*) mean in sql?
what are all the common sql function? : Sql dba
What are the rules to be applied to nulls whilst doing comparisons?
Is hadoop a nosql?
what is the difference between cluster and non cluster index? : Sql dba
Which is faster view or stored procedure?
Is time a data type in sql?
What is implicit cursor in pl sql?
What do you think about pl/sql?
What is difference between primary and secondary key?
Can we commit inside a trigger?
