Hello everyone, I was wondering if geospatial in...
# general
m
Hello everyone, I was wondering if geospatial index is utilized in join (join with distance predicate)?
k
Yes.. filters will get pushed down if possible
m
What if it wasn’t a filter the join condition itself is the distance?
b
You can verify it with : (v2) set explainAskingServers=true; EXPLAIN PLAN FOR ... query should contain FILTER_H3_INDEX or INCLUSION_FILTER_H3_INDEX operators (though case might be different).
k
It depends on the condition.. if you can try to model it as a semi join , then index can be used.. can you share the query