Design aggregations for partitions with 500,000 or more rows

Best Practices Recommendations

For best performance, you should typically design aggregations for each partition. Generally, aggregations will significantly improve the query performance for partitions of significant size.

For More Information

For more information about designing aggregations, see Designing Partition Storage and Aggregations in SQL Server Books Online.

For more information about performance issues related to aggregations, see the section, "Maximizing the value of aggregations," in the SQL Server 2005 Analysis Services Performance Guide.