6 Replies Latest reply: Aug 5, 2012 5:35 PM by va*447258*15 RSS

    to identify relationship

      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