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!
