VIEWS: Takes the output of a query M.VIEWS: Stores the output of a query,

Difference between views and materialized views?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

VIEWS: Takes the output of a query
M.VIEWS: Stores the output of a query,Views can't store
the results of a query

Is This Answer Correct ?

12 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is substitution variable?

1042

What are types of exception?

916

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

963

Explain the update statement in sql

978

How does cross join work in sql?

1007

how to fetch common records from two tables? : Sql dba

1168

what is row? : Sql dba

1219

how to rename an existing table in mysql? : Sql dba

1054

What is a sql*loader control file?

1250

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

965

Explain the components of sql?

1053

What is faster join or subquery?

1008

Can we create index on primary key?

959

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1174

what does myisamchk do? : Sql dba

1008