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
How do I find sql profiler?
What are the sql commands?
what is the difference between a web-garden and a web-farm? : Sql dba
What is interval partition?
What is the process of debugging?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
How to select 10 records from a table?
How can you tell the difference between an index and a view?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What are the types of sql commands?
How do sql triggers work?
what is a unique key ? : Sql dba
What is the best partition size for windows 10?
Does varchar need length?
How do you define a foreign key?