Q:
What is the difference between view and materialized view?
Answer
View:
- Tail raid data representation is provided by a view to access data from its table.
- It has logical structure can not occupy space.
- Changes get affected in corresponding tables.
Materialized view
- Pre calculated data persists in materialized view.
- It has physical data space occupation.
- Changes will not get affected in corresponding tables.
View answer
Workspace
Report Error
Discuss