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

how do you know if your mysql server is alive? : Sql dba

1078

Is postgresql a nosql database?

1160

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

What is the max nvarchar size?

982

Why does sql need a server?

1039

What is normalization sql?

1055

Do foreign keys improve performance?

1022

how to increment dates by 1 in mysql? : Sql dba

978

How to test for null values?

1050

What is data control language?

990

Why do we need sharding?

988

Does sap use sql?

993

What are the events on which a database trigger can be based?

1189

what is the difference between blob and text? : Sql dba

1020

what are the different type of normalization? : Sql dba

1027