🎴 Flashcard Mode
Oracle Practice Test - 10
Card1 / 22
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
Materialized View
💡 Explanation:
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.