Hello everyone,
I was wondering if geospatial index is utilized in join (join with distance predicate)?
k
Kishore G
01/09/2025, 11:22 PM
Yes.. filters will get pushed down if possible
m
meshari aldossari
01/09/2025, 11:28 PM
What if it wasn’t a filter the join condition itself is the distance?
b
Bolek Ziobrowski
01/10/2025, 6:31 AM
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
Kishore G
01/10/2025, 8:02 AM
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