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
Thanks for any insight.