Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22231 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
Which version of sql do I have?
What is a parameter query?
Why schema is used in sql?
what is the difference between sql and t-sql? : Transact sql
how to write date and time literals? : Sql dba
How do I run a sql query in pgadmin 4?
How can I see all tables in sql?
Is primary key always clustered index?
What are the operators used in select statements?
What is the difference between mdf and ndf files?
What is a join?
How do I write a cron which will run a sql query and mail the results to agroup?
In pl/sql, what is bulk binding, and when/how would it help performance?
How do you optimize a stored procedure in sql?
How do you update a sql procedure?
