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

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.