Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22033 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
What is rowid in sql?
What is difference between left and right outer join?
What are operators available in sql?
What is use of trigger?
what is union? : Sql dba
what is 'mysqlcheck'? : Sql dba
What is basic structure of pl sql?
How does rowid help in running a query faster?
What are the different operators available in sql?
what are the different functions in sorting an array? : Sql dba
What is cartesian join in sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Can we use insert statement in function?
Does truncate remove indexes?
How do I view a sql trace file?
