view is a virtual table.view does not contain any data while material view

What is the differnce between view and materialized view

Question Posted / nivedita

Answer Posted / nivedita

view is a virtual table.view does not contain any data
while material view has its own data.material views are the
local copies of remote data.

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

tell me about various levels of constraint. : Sql dba

1035

Is sql dba a good career? : SQL DBA

992

what is commit? : Sql dba

1078

Does mysql_real_escape_string prevent sql injection?

950

Does truncate free space?

1012

How does one load ebcdic data? : aql loader

1176

How to get unique records from a table?

973

What is the usage of sql functions?

1146

What is a delimiter in sas?

1058

How do I pipe the output of one isql to another?

1006

Why we use joins in sql?

985

What is the unique index?

1054

What is sql server and ase?

1024

Can you do multiple joins in sql?

1053

What is procedure function?

1063