What is Materialized View? In What Scenario we Use
Materialized View?
- 2 Answers
- 8529 Views
- Dinesh, Marlabs, I also Faced
- E-Mail Answers
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 are date and time functions in mysql? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
What happens when a trigger is associated to a view?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
What is the purpose of design view?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How many types of tables are there?
Is sql a case sensitive language?
What is the difference between delete and truncate statement in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
Can you selectively load only those records that you need? : aql loader
How to add new employee details in an employee_details table with the following details
What is difference between sql function and stored procedure?
What are local and global variables and their differences?
when is the use of update_statistics command? : Sql dba
