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
(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?