Data Warehouse Performance Tuning & Optimization

Tips for performance tuning and optimization

Friday, May 06, 2005

Insights: Aggregate Tables Defined

This article in DM Review suggests the wrong approach to creating aggregate tables. If you try to build an aggregate table in response to specific business needs, you may end up with a large number of aggregates that become a maintenance headache. Besides, unless I'm missing the point, business users don't need aggregates. What they need is reports that return immediately.

0 Comments:

Post a Comment

<< Home