Oracle 11.2
---
Hi
I have a table which contains geometries of LINES (type 2002) and a table with points (2001).
Now I have to
"search for all points which ...
- are placed at an endpoint of the line
- are placed at a vertex (at the end or inside the line)
- are placed somewhere exactly on the line"
What are the best ideas for it?
Distance is 0?
Point is in vertexlist?
sdo_relate?
Thanks for hints
EDIT:
I'm playing around with SDO_GEOM.RELATE.
It seem to be OK, but the performance seem to be low. So here is a side-effect question:
Is there a difference i performance when I define
"Point_geometry touches Line_geometry" or in the other direction "Line_geometry touches Point_geometry"?
Peter