Question

What is incremental materialized view maintenance?

(a) Modifying all the parts of the view

(b) Modifying only the affected parts of the view

(c) Not modifying the view

(d) None of the mentioned

This question was addressed to me in an interview.

I'm obligated to ask this question of Materialized Views and Advanced Topics in Query Optimization topic in chapter Query Processing and Optimization of RDBMS

Answer 1

Correct choice is (b) Modifying only the affected parts of the view

Explanation: Modifying only the affected parts of the materialized view is called as incremental view maintenance. It is much more efficient than ordinary view management.