AnsweredAssumed Answered

st_geometry performance

Question asked by rob_clark on Feb 17, 2017
Latest reply on Feb 17, 2017 by George_Thompson-esristaff

We are creating a materialized view from two tables via a dblink (all databases on the same server) that will process, initially, roughly 4.5 million records.

 

We are adding a sde.st_geometry column which constructs a point from an X and Y column in one of the tables.

Currently to create 10,000 rows it takes an hour and a half.

 

sde.st_geometry ('point (' || w.SOURCELON || ' ' || w.SOURCELAT || ')', 4267 )

 

Is that expected performance?

 

Removing the line that creates the spatial column and the view will create in a couple of seconds.  So st_geometry is causing a huge performance bottle neck.

 

Oracle 11g

SDE 10.4.1

Oracle Linux 6.7

Outcomes