Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22222 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
Show the two pl/sql cursor exceptions.
Can you have more than one trigger on a table?
how to create a table index in mysql? : Sql dba
Can we use pl sql in sql server?
What is a database event trigger?
How can you select unique records from a table?
Explain scalar functions in sql?
What are the different dml commands in sql?
How to move files from one directory to another in pl sql?
Can dml statements be used in pl/sql?
What is the best free sql database?
How to return an array from java to pl/sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
discuss about myisam key cache. : Sql dba
What is procedure explain with program?
