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.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 02:42:00 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.