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 does it mean to have quoted_identifier on? : Sql dba

1101

Can pl sql procedure have a return statement?

961

What is delete command in sql?

1053

What are analytical functions in sql?

972

Does a primary key have to be a number?

918

What do you understand by pl/sql records?

961

how to create a new table by selecting rows from another table in mysql? : Sql dba

1011

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

918

What is a memo field?

903

What does <> sql mean?

989

Why truncate is used in sql?

937

What is scope of pl sql developer in future?

952

How does index help in query performance?

968

When sql appeared?

1025

How many types of normalization are there?

901