How to optimize speed of a select query

ShaniquaRayford — Thu, 11 Oct 2018 20:40:04 GMT

The issue I am having is that when I run a query using the Esri ST_Geometry package it is

taking up to 5 minutes to give a result. It is possible that it may be because

of the large number of records in the view.

Below is an example of the query I am running:

select sectionnumber from land.fisgridsection_vw

where sde.st_overlaps(sde.st_buffer(

(SELECT shape FROM land.fisgridsection_vw

WHERE sde.st_intersects(sde.st_point(792026,335093,2274),shape) = 1),1),shape)= 1;

My question is "how can I optimize the speed of this query?" Are there any other options

I could use?

Re: How to optimize speed of a select query

JoshuaBixby — Sun, 12 Dec 2021 08:28:22 GMT

Honestly, it is really difficult to troubleshoot performance issues like this in the forums unless you can provide a whole lot more information about the data, SQL execution plans, etc....

Since this involves multiple spatial operations, have you broken the problem down to see at which step the execution time increases the most? For example, how long does it take for:

SELECT shape FROM land.fisgridsection_vw
WHERE sde.st_intersects(sde.st_point(792026,335093,2274),shape)‍‍

topic How to optimize speed of a select query in Geodatabase Questions

How to optimize speed of a select query

Re: How to optimize speed of a select query