What is meant by Materialized view?
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
What is embedded sql in db2?
Are subqueries better than joins?
How subquery works in sql?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is primary and foreign key?
In pl/sql, what is bulk binding, and when/how would it help performance?
What is the usage of nvl function?
What are analytic functions in sql?
Is pl sql a programming language?
What are three advantages to using sql?
What is clustered and nonclustered index in sql?
What is the maximum number of columns in sql table?
What is character functions?
What are the three pl sql block types?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba