Interested to Buy Any Domain ? << Click Here >> for more details...
What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 9526 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 |
What does t sql mean?
What are properties of the transaction?
Which are the different case manipulation functions in sql?
What is trigger types of trigger?
How delete a row in sql?
Describe types of sql statements?
what is sql profiler
What are all the different normalization?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger ? Why ?
Can we call a function containing dml statements in a select query?
Should I use mbr or gpt?
What is difference between hql and sql?
-
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)
