In a DSS application, the sales summary report queries data from seven different tables and groups the data by region and period. Which of the following storage structures is a good design choice to improve query performance?

Materialized views are ideal for DSS applications as they pre-compute and store aggregate results, dramatically improving query performance for complex, multi-table joins and grouping operations. The data is already summarized and stored physically, so queries run against the pre-aggregated data rather than recomputing each time. IOTs and clusters are better suited for OLTP workloads with high single-row access patterns.