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
How many functions are there in sql?
Does db2 use sql?
What is exit statement?
how to select first 5 records from a table? : Sql dba
How can we find duplicate records in a table?
What do you mean by rowid?
How many types of primary keys are there?
What is a sql trace file?
How do you create a db file?
Define join and name different types of joins?
Why do we use partitions in sql?
What are the constraints available in sql?
What is the difference between delete and truncate commands?
Can we write dml inside a function in sql server?
What is package in pl sql with an examples?