ST_Contains(left, right) - left contains right or ST_Intersects(left, right) - left and right intersect
Plans RangeJoinExec
for inner joins on spatial relationships ST_Contains(a, b)
and ST_Intersects(a, b).
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.
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)