Materialized Views

Problem

The nightly financial report runs a query that takes 45 minutes because it aggregates millions of rows. Since the data only changes once a day, the DBA suggests saving the result set physically to disk. Write a query that outputs concept with the value: "A materialized view caches the results of a complex query on disk to speed up subsequent reads."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution