Differentiation between view and materialized view

Question

Write down the differentiation between view and materialized view?

Answer 1

View:

• Tail raid data representation is offered through a view to access data from its table.
• It has logical structure can’t take up space.
• Alters get influenced in corresponding tables.

Materialized view:

• Pre computed data perseveres in materialized view.
• It has physical data space activity.
• Alters will not get influenced in corresponding tables.