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.