Difference between views and materialized views?
Answer Posted / pinkey
A view is just a stored query and has no physical part.
Once a view is instantiated, performance can be quite good,
until it is aged out of the cache. A materialized view has
a physical table associated with it; it doesn't have to
resolve the query each time it is queried. Depending on how
large a result set and how complex the query, a
materialized view should perform better.
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Explain what is a column in a table?
What is trigger and types?
How do I view a view in sql?
what is denormalization. : Sql dba
What are the parts of a basic sql query?
What is the most important ddl statements in sql are?
Is primary key an index?
What is secondary key?
What is sql and how does it work?
Does truncate release storage space?
explain normalization concept? : Sql dba
Explain the difference between triggers and constraints?
what are date and time data types? : Sql dba
How do I view a sql database?
What is a null value?