Hi,

Please first subscribe to the mailing list and then send emails. Otherwise,
the community might not be able to receive your email and you might not
receive our response. To subscribe, please send an email (leave the subject
and content blank) to [email protected]

This spatial query will leverage spatial index automatically. Sedona will
build spatial indices on the fly to perform this query. Once the query is
completed, Sedona will drop the index. So this is a one-time index.  If you
check the log, you will see WARN: didn't find spatial index. Will build
spatial index on the fly.

Thanks,
Jia

On Sat, Feb 4, 2023 at 3:42 PM 可为 <[email protected]> wrote:

> Hello expert,
> &nbsp; &nbsp; &nbsp;I&nbsp; have&nbsp; a question&nbsp; to&nbsp;
> consult.&nbsp; Does  spatial query  use spatial index ? Thanks.
>
>
> e.g.
> SELECT *&nbsp;
> FROM pointdf&nbsp;
> WHERE ST_Intersects(ST_PolygonFromEnvelope(1.0,100.0,1000.0,1100.0),
> pointdf.arealandmark)

Reply via email to