Forum Discussion
ezpz97
Mar 26, 2025Copper Contributor
SQL Server Stream aggregate vs Hash match aggregate
Hello. I am a new SQL Server engineer.
While looking at the execution plan of a query that SUM()s values of int type based on the range of the date column of datetime type, I found that SUM() processing is handled by Stream Aggregate and Hash match aggregate on a case-by-case basis.
The table is composed of a Clustered Index with Date as the key. I think it changes to Hash match processing as the index search range increases, but I don't know the difference between the two processing methods and what criteria determine the processing method. Can you give me a good answer?
1 Reply
- olafhelperBronze Contributor
Please avoid double posts:
SQL Server Stream Aggregate vs Hash match Aggregate | Microsoft Community Hub