JoinHint
The types of join hints.
Hash = 2
HASH was used.
Loop = 1
LOOP was used.
Merge = 3
MERGE was used.
None = 0
Nothing.
Remote = 4
REMOTE was used.