This discussion is archived
6 Replies Latest reply: Aug 5, 2012 3:35 PM by va*447258*15 RSS

to identify relationship

va*447258*15 Newbie
Currently Being Moderated
Hi All,

I have two themes one as point layer, another one as polygon, and want to select all points which will intersect or touch polygon layer at any point, i have used following query but it takes enough time, is there any way to perform it more efficiently. Thanks in advance;

select a.*, b.*
from point_geometry a,
poly_geometry b
where SDO_RELATE(A.Geom, B.Geom, 'mask=anyinteract querytype=WINDOW') = 'TRUE';

Best Regards


  • Correct Answers - 10 points
  • Helpful Answers - 5 points