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 text? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
Can I join the same table twice?
What do you mean by rowid?
Can we call stored procedure in function?
What is a pdo connection?
Can I create table without primary key?
What is the difference between sum and count in sql?
How does join work in sql?
Is subquery faster than join?
what does the t-sql command ident_current does? : Transact sql
What is a full join?
Write an sql query to select all records from the table?
What is pl sql in oracle?
What is linq to sql?