Interested to Buy Any Domain ? << Click Here >> for more details...
What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 9483 Views
- Dinesh, Marlabs, I also Faced
- E-Mail Answers
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 |
Define a temp table?
How do I get sql certification?
What is a merge query?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
Can We write bulk collect statement in triggers?
What is a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
What is date functions?
Can we use delete in merge statement?
What is substitution variable?
What is the purpose of design view?
Can we call stored procedure in function?
What packages(if any) has oracle provided for use by developers?
-
Oracle (3259) - 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)
