Hi, 1. Sedona left join does not utilize the Sedona optimized spatial join algorithm, which subsequently means it will not use spatial indexes. 2. One possible alternative is to use Sedona indexed Broadcast join which supports all sorts of join types. See https://github.com/apache/sedona/pull/711
Thanks, Jia On Sun, Feb 5, 2023 at 9:30 PM 可为 <[email protected]> wrote: > Hello expert， > > How to make the left join to use spatial index？ > > e.g.val sql = "select a.id as aid,b.id as bid from targetfeature a LEFT > OUTER JOIN inputfeature b on ST_Intersects(ST_GeomFromWKB(a.geom), > ST_GeomFromWKB(b.geom)) " > > > > Thanks.
