今天没时间,贴两个链接
比较相同图元的sql语句.select Objectid 结果集数目多于一个时,运算速度巨慢
SELECT A.*
FROM temp_tudi_1 A, temp_tudi_1 B
WHERE B.Objectid in (select objectid from temp_tudi_1 where objectid =1 or objectid =2) and
SDO_EQUAL(A.shape, B.shape) = 'TRUE';
http://www.cnblogs.com/upDOoGIS/archive/2009/05/20/1469871.html