Note: To see the new Adaptive Join operator - download SQL Server Management Studio - 17.0 .
|AdaptiveThresholdRows||Shows the threshold use to switch from a hash join to nested loop join.|
|EstimatedJoinType||What we think the join type will be.|
|ActualJoinType *||In an actual plan, shows what join algorithm was ultimately chosen based on the threshold.|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.