Design aggregations for partitions with 500,000 or more rows

This rule analyzes partitions to determine whether aggregations have been designed for each partition that has 500,000 or more rows.

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 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.

Community Additions