What is the differnce between view and materialized view
Answer Posted / yaswanth
A view will takes the output of the query. But a materialized
view stores the output of the query which is not possible in
view
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a full join?
Explain cursor types?
Is pl sql better than sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
Do we need to rebuild index after truncate?
What are different clauses used in sql?
Define concurrency control. : Transact sql
What are some emotional triggers?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What are different types of functions in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
Describe sql comments?
What is exit statement?
What does := mean in pl sql?
What kind of join is join?