Details

hash and stream aggregation

Speaker: Torsten Strauss

Duration: 60 minutes

Track: Enterprise Database Administration & Deployment

The session (level 300) will introduce the differences between the hash and stream aggregation. 
You will see the differences in terms of the internal algorithm, performance, scalability, hardware consumption and understand the limitations.
In the end of the session you will able to predict which physical aggregate operator SQL Server will implement to run the query and you have learned to implement the right index strategy to boost the query execution.

Accompanying Material


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids