What is meant by Materialized view?
- 2 Answers
- 6355 Views
- iGate, Marlabs, Polaris, I also Faced
- E-Mail Answers
Answer Posted / nitin
Materialized views are used to precompute a heavy joins instead of executing a joins again n again. Moreover it physically stores the data unlike views where it is conceptually. Materialized views can be refresh on timely manner.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what is an index?
Can pl sql procedure have a return statement?
Can %notfound return null after a fetch?
Is postgresql a nosql database?
Can we use ddl statements in stored procedure sql server?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
What is the best free sql database?
What are secondary keys?
Can we create clustered index without primary key?
what is a constraint? : Sql dba
What is pl sql commands?
What is the most common sql injection tool?
How to add, remove, modify users using sql?
Explain the types of joins in sql?
Can you load data into multiple tables at once? : aql loader
