Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SDO_Relate

2668299May 7 2014 — edited May 9 2014

Is there wrongs in Oracle Spatial documentation !??


My senario is:

1. the Geom 1 is a one line geometry and comes from a table

2. Geom2 is a ploygon and contains many geometries in a table also.

I used the folowing syntax:

select /*+ ordered */ ..from table2,table1 where SDO_Relate(Geom2,Geom1,'mask=anyintraction')= 'TRUE 

which gives me the best performance (the fastest ==2 Minutes).

Using the recommendation written in Spatial reference, i should use:

from table1,table2 where SDO_Relate(Geom2,Geom1,'mask=anyintraction')= 'TRUE

but i get worse performance! (4 Min.)

Furthermore, ccording to oracle reference, it is possible to pass two or more Geometries to Geom2 (using ordered hint and putting Geom2's table at first in the from clause):

..SDO_Relate(Geom1,Geom2,'mask=anyintraction')= 'TRUE'

which even much worse than the two above solutions.

Comments

jflack
You might want to ask this in the ApEx forum - 3139 This is the ApEx Listener forum.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 6 2014
Added on May 7 2014
8 comments
3,147 views