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
Adding more groups for better visibility. https://community.esri.com/groups/geodatabase?sr=search&searchId=5f91017e-08f0-41c2-85a3-e78626b0c21... https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=dd891da0-22b3-4750-ad52-c...