What is Materialized View? In What Scenario we Use
Materialized View?
Answer Posted / 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 |
Post New Answer View All Answers
What does bitemporal mean?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Do prepared statements prevent sql injection?
What is oracle sql called?
What is database migration?
What is mutating table error?
what is not null constraint? : Sql dba
what is sql in mysql? : Sql dba
Can we use ddl statements in stored procedure?
How to add a column ‘salary’ to a table employee_details?
Which command is used to delete a package?
What is the purpose of the partition table?
Mention what pl/sql package consists of?
How does a covering index work?
How do I create a sql database?