Oracle 18c; 10.7.1 EGDB; ArcGIS Desktop 10.7.1
I have a non-spatial WORKORDER table that has X & Y columns. The table has 10,000 records.
I’ve created an XY event layer from the table in ArcMap.
The performance of the XY event layer has been surprisingly good, considering the shape field is generated on-the-fly. As far as I can tell, the XY event layer refreshes in the map almost as fast as a feature class does (the difference is negligible). Whereas a spatial view on the same table performs much slower (using an SDE.ST_GEOMETRY or an SDO_GEMETRY column; generated on-the-fly).
I would like to understand more about how different layer types perform in ArcGIS.
Do XY event layers have any built-in/dynamic optimization mechanisms (like a spatial index) that would account for the surprisingly good performance?