Home » Server Options » Spatial » SDO_RELATE Performance (Oracle 10g , CentOS)
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.
Previous Topic: Results from outside an SDO_FILTER
Next Topic: Merging line geomrtry in a particular order
Goto Forum:
  


Current Time: Sat Dec 20 08:35:48 CST 2014

Total time taken to generate the page: 0.10274 seconds