Dynamic and materialized view

Write a short note on the difference between a dynamic and materialized view?

E

Expert

Verified

A dynamic view might be created every time that a particular view is requested by a user. A materialized view is created and updated infrequently and it should be synchronized with its associated base table(s).

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.