Difference between views and materialized views?
- 5 Answers
- 21219 Views
- BirlaSoft, I also Faced
- E-Mail Answers
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
Which sorts rows in sql?
What is primary key in db?
Is sql developer case sensitive?
What are the different types of a subquery?
Why having clause is used in sql?
How do I create an index in word?
What are the different datatypes available in PL/SQL?
What is character functions?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
how to calculate the difference between two dates? : Sql dba
Why indexing is needed?
What is the most restrictive isolation level? : Transact sql
how to analyze tables with 'mysqlcheck'? : Sql dba
Does inner join return duplicate rows?
