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

Why is theta join required?

1150

What is on delete restrict?

1008

what are the advantages and disadvantages of views in a database? : Sql dba

1046

What is sql procedures and functions?

1016

how to add a new column to an existing table in mysql? : Sql dba

1082

How do I view tables in sql developer?

960

what is 'mysqlimport'? : Sql dba

1064

How do I remove duplicates in two columns?

1079

how to rename an existing column in a table? : Sql dba

1029

what is auto increment? : Sql dba

1018

What is sql lookup?

932

What is sql dialect?

1126

How do you change a value in sql?

1024

Explain the difference between rename and alias?

1021

What is %type in sql?

972