OraFAQ Forum: Spatial » SDO_RELATE Performance

Home » Server Options » Spatial » SDO_RELATE Performance (Oracle 10g , CentOS)

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

SDO_RELATE Performance [message #517667]

Wed, 27 July 2011 03:49

ntt85
Messages: 34
Registered: July 2011
Location: vietnam

Member

Hi all,

I have to use SDO_RELATE to determine a point is in the polygon area :

SELECT ct.cc_2
FROM vc_session s, vn_cities ct
WHERE s.id=445932
AND SDO_RELATE(s.location, ct.geom, 'mask=anyinteract')='TRUE';

It executed in 1 second.
My application must scan a large sessions at the same time.My vn_cities have 64 records with geometry data.
So I want to find a solution to improve performance.Anyone can suggest for me? Thanks a lot.

Report message to a moderator

Previous Topic:	Results from outside an SDO_FILTER
Next Topic:	Merging line geomrtry in a particular order

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 16:48:27 CDT 2013

Total time taken to generate the page: 0.43902 seconds