Answer
A hash match creates an in-memory hash table for joins and aggregates.
If memory is insufficient ? spills to TempDB ? huge slowdown.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ