TSQL Execution Plan
Hash Match
use each row from the top input to build a hash table, and each row from the bottom input to probe into the hash table, outputting all matching rows.
Clustered Index Scan
Scanning a clustered index, entirely or only a range.
Compute scalar
Compute new values from existing values in a row
Stream aggregate
Compute summary values for groups of rows in a suitably sorted stream.