AnsweredAssumed Answered

Slow query on SDE 9.3 spatial view

Question asked by gmichael on Oct 18, 2018

Hello,

 

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.

Outcomes