O'Reilly logo

SAP® BW: A Step-by-Step Guide by P.E. Henry Fu, Ph.D. Biao Fu

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

The ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required