按多列汇总数据

实际上,对于这样的问题,您应该以简单的方式编写报告,然后查看性能是否满足业务需求。如果不是, 然后 看看优化策略。

你 可能 通过将中间结果存储在表变量或临时表中,然后对其运行更多聚合,可以获得一些性能提升。例如,只有两个结果集:

SELECT COUNT(*) as cnt, State, AgeBracket 
INTO #t
FROM YourTable
GROUP BY State, AgeBracket;

SELECT SUM(cnt) AS cnt, State FROM #t GROUP BY State;
SELECT SUM(cnt) AS cnt, AgeBracket FROM #t GROUP BY AgeBracket;