Is This Content Helpful?
We're glad to know this article was helpful.
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 ".
To disassociate the sde.st_contains operator from the domain, index st_spatial_index connect as the SDE user in SQL*Plus and execute the following command:
SQL> ALTER INDEXTYPE st_spatial_index
2 DROP st_contains (sde.st_geometry, sde.st_geometry);