Difference between views and materialized views?
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 |
Post New Answer View All Answers
What is a crud api?
What are the types of views in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How can I tell if sql is running?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What are the types of queries in sql?
how to drop an existing index in mysql? : Sql dba
What is the difference between cross join and natural join?
What is difference between hql and sql?
What is right join sql?
what are enums used for in mysql? : Sql dba
how to get a list of all tables in a database? : Sql dba
What is the difference between python and sql?
Can we join two tables without common column?
What is lexical units in pl sql?