What is the differnce between view and materialized view
Answer Posted / papia
view does not contain actual data but MV contains data.MV
needs to be refereshed after a particular interval.Bit when
a view is queried it actually queries the underlying tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to use 'mysql' to run sql statements? : Sql dba
What is pl sql package?
What is keys and its types?
what is sql server agent? : Sql dba
How do you pronounce sql?
how do you tune the slow running queries in oracle db , explain the methodology
Do stored procedures prevent sql injection?
What is lexical units in pl sql?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is a pdo connection?
What are the commands used in sql?
In a distributed database system, can we execute two queries simultaneously?
How do you explain an index?
What is pl/sql table? Why it is used?
How do I run a sql query?