Help Me/Question What Is Difference Between A Dynamic And Materialized View?

steve taylor

White Belt
View is the logical virtual table created by select query in SQl. But the result is not stored any where in the storage media and every time we need to fire the query when we needed the data.
Materialized view are also logical view of data secected by query but the result of the query will stored in the table and in the storage media.