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.

Sort

Sort the input

Nested loops

For each row in the top (outer) input, scan the bottom (inner) input, and output matching rows.

Merge join

Match rows from two suitably sorted input tables and exploiting their sort order.

Resources

• icons