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 sqlite used for?

1048

What is the difference between inner join and left join?

1038

What is mdf ldf and ndf?

1057

how many sql dml commands are supported by 'mysql'? : Sql dba

1166

What is a field in a database?

1102

How do I start pl sql?

997

what is the difference between inner and outer join? Explain with example. : Sql dba

1067

What is a heap in sql?

1145

What is a database event trigger?

1211

What is data profiling in sql?

1138

What is the use of prepared statement?

1072

what is unique key constraint? : Sql dba

1099

What is a sql statement?

1018

Mention what are the benefits of pl/sql packages?

1155

what is cursor. write example of it. What are the attributes of cursor.

1462