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 (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

0 votes
1 answer
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...