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

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

1 Answer

0 votes
by (40.3k 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.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !