0 votes
1 view
in SQL by (20.3k points)

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

1 Answer

0 votes
by (36.7k points)

When views are accessed, it runs the definition of a query each time.

Views are always only virtual.

 Whereas, Materialized views get updated periodically based on the query definition. This is disk-based.