AnsweredAssumed Answered

How to optimize speed of a select query

Question asked by srayford92 on Oct 11, 2018
Latest reply on Oct 11, 2018 by bixb0012
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?

Outcomes