Plans RangeJoinExec
for inner joins on spatial relationships ST_Contains(a, b)
and ST_Intersects(a, b).
ST_Contains(left, right) - left contains right or ST_Intersects(left, right) - left and right intersect
ST_Contains(left, right) - left contains right or ST_Intersects(left, right) - left and right intersect
left side of the join
right side of the join
expression for the first argument of ST_Contains or ST_Intersects
expression for the second argument of ST_Contains or ST_Intersects
boolean indicating whether spatial relationship is 'intersects' (true) or 'contains' (false)
Plans
RangeJoinExec
for inner joins on spatial relationships ST_Contains(a, b) and ST_Intersects(a, b).Plans
DistanceJoinExec
for inner joins on spatial relationship ST_Distance(a, b) < r.Plans
BroadcastIndexJoinExec for inner joins on spatial relationships with a broadcast hint.