When troubleshooting performance issues with SDE.ST_GEOMETRY queries in Oracle 12c/18c, I’ve found that the ST_PointN function is very slow when used in bulk (10x slower than many other ST_GEOMETRY functions).
The ST_PointN function doesn’t seem do anything special. It’s not doing complex spatial analysis or anything like that; it just gets a specific point from the SHAPE blob. So I wonder if there might be an issue with how it’s designed.
For example, changing the the function so that it’s DETERMINISTIC might make it faster.
Could Esri investigate/improve the performance of that function?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.