A view will takes the output of the query. But a materialized view stores

What is the differnce between view and materialized view

Question Posted / yaswanth

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

Please Help Members By Posting Answers For Below Questions

what is the difference between a web-garden and a web-farm? : Sql dba

1075

What are different functions in sql?

935

Explain the difference between triggers and constraints?

967

What is a constraint? Tell me about its various levels.

1150

Why triggers are used?

981

how to create a new table in mysql? : Sql dba

978

How to create a menu in sqlplus or pl/sql?

1114

what is bdb (berkeleydb)? : Sql dba

1024

What is varray in pl sql?

1067

Which is faster joins or subqueries?

985

Can sql developer connect to db2?

1030

What is a natural join sql?

963

Which one is faster ienumerable or iqueryable?

930

How are functions and procedures called in PL/SQL?

1213

When should I use nosql database?

1000