Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22290 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 pl sql collection?
What are the different dml commands in sql?
What are the parts of a basic sql query?
List out the acid properties and explain?
Could you please provide oca (oracle 10g) dumps for my certification ?
State some properties of relational databases?
what is sql server agent? : Sql dba
Does oracle roll back the transaction on an error?
How many aggregate functions are available there in sql?
Explain what is dbms?
What is the difference between sql and mysql?
Does normalization improve performance?
Explain the significance of the & and && operators in pl sql.
Why stored procedure is better than query?
How would you pass hints to the sql processor?
