OraFAQ Forum: Spatial » Oracle Spatial Query peformance

Home » Server Options » Spatial » Oracle Spatial Query peformance (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Spatial Query peformance [message #565895]

Fri, 07 September 2012 16:12

gentleman777us
Messages: 122
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 23:26:26 CST 2025