SDE and Domain Spatial Index (Sel - Undefined)

Discussion created by fss_gsm on May 14, 2013
Latest reply on May 20, 2013 by fss_gsm
We have a point feature class with approximately 800,000 features loaded into a 10.1 SDE environment (Oracle 11gR2).

I have noticed very poor performance compared to the the 9.3 environment we initially used. On examining the explain plan being used when ArcMap is attempting to display these points, I noticed that the domain index seems to be using an undefined "selectivity", as per the attached screenshot.


Reading online, ESRI seems to suggest that this situation should never eventuate (although it does not mention 10/10.1 for affected software). See: http://support.esri.com/en/knowledgebase/techarticles/detail/32594

It appears that we have this same poor performance on multiple database servers, and dropping and rebuilding the index does not seem to resolve the issue.

Has anybody got any suggestions or noticed similar behaviour in their environment?