AnsweredAssumed Answered

Slow query on SDE 9.3 spatial view

Question asked by gmichael on Oct 18, 2018
Latest reply on Mar 7, 2019 by bnayak-esristaff



I have a spatial view created with sdtable -o create_view.

The view joins multiple tables, all join fields in all tables are indexed.

For some reason Identify on the view is very slow.

Digging down to ADF code, I found that query.Identify is very slow.

Can't find the reason.

The server has a plenty of resources.

Oracle has 4Gb of memory.


ArcGIS Sever 9.3.1, ArcSDE 9.3.1, ADF

Oracle 11g


Thanks for any insight.