What is the difference between ‘view’ and ‘materialized view

[mayur-srivastava-969b4813 (Mayur Srivastava)]

View:

• Tail raid data representation is provided with a view to access data from its table.
• It has logical structure that does not occupy space.
• Changes get affected in the corresponding tables.

Materialized view:

• Pre-calculated data persists in the materialized view.
• It has physical data space occupation.
• Changes will not get affected in the corresponding tables.