Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between views and materialized views?
- 5 Answers
- 22050 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 clause?
What is the process of debugging?
what is the use of double ampersand (&&) in sql queries?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Which sql most popular?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what is bcp? When is it used?
What are different categories of sql commands?
Why does sql need a server?
how do you login to mysql using unix shell? : Sql dba
Explain what is rdbms?
How does one load ebcdic data? : aql loader
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
I need a function for a train ticket reservation please answer it thanks in advance
how would you get the current date in mysql? : Sql dba
