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
Can we connect to postgresql using sql developer?
What is pl sql in oracle?
How many types of sql are there?
What is data manipulation language?
What is the difference between unique and primary key constraints?
how mysql optimizes distinct? : Sql dba
What is a sql select statement?
What is right join in sql?
What are triggers in sql?
Explain exception handling in pl/sql?
Is pl sql a scripting language?
Why we use triggers in mysql?
What is use of term?
What is rownum?
Is sql an operating system?