Because Oracle operators are unable to use a domain index as the access path for the second argument in an operator's specification, the sde.st_contains operator should not be associated with the domain index st_spatial_index.Instructions provided describe how to disassociate the st_contains operator from the domain index st_spatial_index in Oracle.
For additional information about the limitations of Oracle's extensible indexing and optimizer, see ESRI Knowledge Base article, "Poor query performance when using the st_contains operator in Oracle ".
SQL> ALTER INDEXTYPE st_spatial_index
2 DROP st_contains (sde.st_geometry, sde.st_geometry);
Get help from ArcGIS experts
Download the Esri Support App