What is the difference between view and Materialized View in oracle database?
Question is closed for new answers.
meda Changed status to publish 08/03/2022
A materialized view is a dynamic table that contains SQL query command to generate rows. Materialized view also stores the actual selectable rows where the MV is created from. MV rows are updated automatically when the base tables are updated.
When we comes to a View, it is a logical table that represents the data that is stored in other tables or views , or both and does not store the actual rows.
meda Changed status to publish 22/02/2022