What is meant by Materialized view?
Answer Posted / nitin
Materialized views are used to precompute a heavy joins instead of executing a joins again n again. Moreover it physically stores the data unlike views where it is conceptually. Materialized views can be refresh on timely manner.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is %type in pl sql?
What is %rowtype in pl sql?
Is full outer join same as cross join?
Explain the select statement in sql?
How do I debug a stored procedure?
How do you optimize a stored procedure query?
how to shutdown mysql server? : Sql dba
How is pl sql different from sql?
Can a primary key be a foreign key?
how to see the create table statement of an existing table? : Sql dba
What is a null value?
What is a unique key and primary key and foreign key?
What does stand for in sql?
Is sql procedural language?
What is trigger types in sql?