Chapter 13. Performance Tuning
Performance is a critical issue in developing a data warehouse because of the size of data in the system. Earlier in this book, we explicitly discussed techniques to help improve performance. For example, in Chapter 7, we considered how to design an InfoCube so that its queries will have better performance.
Two types of performance measurements exist: system throughput and response time. System throughput usually applies to OLTP systems, which are designed to process thousands or even millions of small transactions per day. In contrast, response time typically applies to OLAP systems, which are designed to process massive parallel queries that fetch and sort hundreds of thousands of records from various tables.