CHAPTER 15Aggregates
Optimization of data warehouse performance is a never-ending process. As technology vendors have improved the capabilities of computer hardware and software, warehouse developers have responded by storing and analyzing larger and more granular sets of data.
In this ongoing quest for performance, the most powerful and effective tool at your disposal is the aggregate. Planned and integrated carefully, aggregates can have an extraordinary impact on the performance of your data warehouse. Their benefits can be realized without significant investment in specialized hardware and software, using tools that are already present in the data warehouse. Additional tools may help create and manage aggregates, but they are not required. ...
Get Star Schema The Complete Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
