title: Oracle SDO_JOIN, how long does it takes?
body: <p>I wanna use the SDO_JOIN-Operator to selfJoin a table. 
  The table has this Structure:
  ID         VARCHAR2(20)<br>
  SHAPE      SDO_GEOMETRY() </p>
  
  <p>The table has 25778 rows.</p>
  
  <p>The following SDO_JOIN-Statement needs 90 seconds: </p>
  
  <pre><code>SELECT w.id as id1, w2.id as id2
  FROM TABLE(SDO_JOIN('nodesWays', 'SHAPE', 'nodesWays', 'SHAPE', 'mask=ANYINTERACT')) c,
  nodesWays w, nodesWays w2
  WHERE c.rowid1 = w.rowid AND c.rowid2 = w2.rowid;
  </code></pre>
  
  <p>Is 90 Seconds a normal time or is it too high. I don't have an idea what is a good time for execution.</p>
  
  <p>Bye, Andre</p>