1.

What Is The Main Difference Between View And Materialized View?

Answer»

The main difference between view and MATERIALIZED view is as follows:

View:

  1. DATA REPRESENTATION is provided by view where the data is accessed from its table.
  2. View has a logical structure which does not occupy space
  3. All the changes are affected in corresponding tables.

Materialized View:

  1. Within materialized view, pre-calculated data is available
  2. The materialized view has a PHYSICAL structure which does occupy space
  3. All the changes are not REFLECTED in the corresponding tables.

The main difference between view and materialized view is as follows:

View:

Materialized View:


Discussion

No Comment Found

Related InterviewSolutions