Denormalization Concept

Problem

The analytics dashboard takes 10 seconds to load because it joins 15 highly normalized tables. The architect suggests storing the pre-calculated total order value directly on the customer record to speed up reads, trading off write speed and storage. Write a query that outputs concept with the value: "Denormalization intentionally adds redundant data to tables to improve read performance at the expense of write performance."

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