This content has been marked as final. Show 3 replies
Are your geometry 3D or 2D, geodetic or non-geodetic(projected)?
How many rows in PARKS_SURVEYS? How complex these geometries?
select max(SDO_UTIL.GETNUMVERTICES(geometry)), avg(SDO_UTIL.GETNUMVERTICES(geometry)) from PARKS_SURVEYS
Edited by: yhu on Jun 27, 2012 2:34 PM
2D and projected. I also found some geometries that are considered valid in 10g but not in 11g and it caused the spatial index failed to be recreated.
As more validations are done in 11g, it could be slower than 10g.
Anyway, I have filed a performance bug on this issue.