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 Linux 6.7