Which statement describes the speed benefits of materialized views?

• A. Materialized views speed equality searches only.
• B. Materialized views speed range searches only.
• C. Materialized views speed equality and range searches, for the subset of rows and columns included.
• D. Materialized views cannot be used with flattening JSON.

Answer: (C)

Materialized views speed up queries by serving precomputed results for a defined subset of rows and columns. When a query uses the same columns and predicates that the MV was built with—such as equality or range conditions—the optimizer can answer from the MV instead of scanning the base tables, delivering faster results. The speed benefit applies only to those queries that align with the MV’s included data; queries that access other columns or different predicates won’t benefit as much. And the idea that materialized views can’t be used with JSON flattening isn’t accurate—an MV can be defined on a flattened JSON path, providing faster access for those queries as well.