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

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

SELECT A.*
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.


Thanks
- 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: Thu Jul 24 15:39:51 CDT 2014

Total time taken to generate the page: 0.12289 seconds