In a DSS application, the sales summary report queries data from seven different tables and groups the data by region and period. Which one of the following storage structures is a good design choice to improve query performance?
-
IOT
-
Cluster
-
Materialized View
-
Partion Table
C
Correct answer
Explanation
Materialized Views pre-compute and store complex query results, especially aggregations from multiple tables. For a DSS (Decision Support System) reporting query joining 7 tables with GROUP BY operations, a Materialized View eliminates the need to re-execute the expensive join and aggregation on each report run.