Home » Server Options » Spatial » Oracle Spatial Query peformance (Oracle 11g)
Oracle Spatial Query peformance [message #565895] Fri, 07 September 2012 16:12
Messages: 121
Registered: April 2005
Senior Member

Any ideas on how to improve the performance of the following spatial query.

FROM (select r.category, r.subcategory, r.name, r.lat, r.lon, sdo_geom.sdo_distance(r.geom, latlon2geom(41.566345, -78.01567), 0.5, 'UNIT=MILE') DIST, recid, nvl(source, 'DEPT2010') as source from (select * from LOCATIONS where sdo_within_distance(geom, latlon2geom(41.566345, -78.01567), 'DISTANCE=1 UNIT=MILE')='TRUE' and
upper(category) = 'PARKS')r order by DIST)A
WHERE rownum < =1;

Any ideas to improve the performance of the query is greatly appreciated.

- Shekar
Previous Topic: declare geom SDO_GEOMETRY causing oracle mem usage increase
Next Topic: create SDO_ORDINATE_ARRAY from number array
Goto Forum:

Current Time: Wed Oct 07 02:25:54 CDT 2015

Total time taken to generate the page: 0.13092 seconds