Sql – the difference between Views and Materialized Views in Oracle

materialized-viewsoraclerelational-databasesqlview

What is the difference between Views and Materialized Views in Oracle?

Best Solution

Materialized views are disk based and are updated periodically based upon the query definition.

Views are virtual only and run the query definition each time they are accessed.