Oracle ST_GEOMETRY update performance (ArcGIS 10.3, Oracle 11.2.0.4.0)

2274
1
01-22-2016 03:51 AM
GertrudWaich1
New Contributor

Hi,

I have to convert frequently 177723 points to ST_GEOMETRY in a geodatabase in Oracle. The points are stored in a table called PARAMS in a character field (Temp_Geometry) in the following format:

point ( 7.0   3.0 )

point (55.0 63.5)

....

The update of the GEOMETRY with the SQL statement below takes 18 minutes!

SQL> update PARAMS set GEOMETRY = (sde.st_geometry(Temp_Geometry,4326));

177723 rows updated.

Elapsed: 00:18:28.09

Updates on other fields are done within seconds -->

SQL> update PARAMS set Valid_To=sysdate where to_char(VALID_TO,'YYYY-MM-DD') = '9999-12-31';

177723 rows updated.

Elapsed: 00:00:04.14

Droping the spatial index does not have any influence on the performance. Any ideas how to speed up the ST_Geometry update?

Thanks!

Tags (1)
0 Kudos
1 Reply
George_Thompson
Esri Frequent Contributor

Adding a bigger audience.....

Geodatabase

--- George T.
0 Kudos