- Materialized view replicates the retrieved data physically.
- This replicated data can be reused without executing the view again. This type of view is also known as "SNAPSHOTS".
- Materialized view reduce the processing time to regenerate the whole data.
- It helps remote users to replicate data locally and improve query performance.
- The challenging part here is to synchronize the changes in materialized views underlying tables.
- Needs to be refreshed to stay updated
- Improves performance on complex queries
CREATE MATERIALIZED VIEW mat_emp_view AS
SELECT emp_id, salary FROM emp1;
