What is meant by Materialized view?
- 2 Answers
- 6367 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
Cite the differences between execution of triggers and stored procedures?
How to handle bulk data?
What is sql table?
What is the maximum database size for sql express?
What is the difference between left outer join and left join?
Explian rowid, rownum? What are the psoducolumns we have?
what is log shipping? : Sql dba
Is it possible to update views?
how to drop an existing table in mysql? : Sql dba
What is the difference between rollback and rollback to statements?
Can we use two order by clause in query?
How do I install sql?
What are different clauses used in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
Does google use sql?
