What is Materialized View? In What Scenario we Use
Materialized View?
Answers were Sorted based on User's Feedback
Answer / chandan kumar
The above answer is right till here....view is a virtual
table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also
same
like the view but it exist in rdbms.
We use the Materialized View in that Senerio when we have
large amount of database and we need to refresh that in a
time being.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / thanigesan.m
view is a virtual table that doesn't exist in rdbms,it is
associated with the SELECT statement materialized is also same
like the view but it exist in rdbms.
we use materialized view
e.g if we r having a table with 4 columns
empno ename sal comm
33 xxxy 1000 234
we can create a materialized view as totalsal by sum that 2
columns....
| Is This Answer Correct ? | 5 Yes | 1 No |
Is sql a microsoft product?
what is uncommittable transactions? : Transact sql
define sql update statement ? : Sql dba
What is blind sql injection?
what is collation? : Sql dba
What is a schema sql?
Difference between global and parameter variables?
what are enums used for in mysql? : Sql dba
What is a record in pl/sql?
What is full join?
What are field types?
What is sharding in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)