Difference between views and materialized views?
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 is left join in postgresql?
What does rownum mean in sql?
Which command is used to call a stored procedure?
Why do we use procedures?
what is column? : Sql dba
Is there any restriction on the use of union in embedded sql?
Does view store data in sql?
What is sqlca in db2?
Explain unique key in sql.
Does sql profiler affect performance?
Why trigger is used in sql?
What is example of database?
What does cursor do in sql?
What is pivot in sql?
Is sql between inclusive?