Is This Content Helpful?
We're glad to know this article was helpful.
SDE users querying SDO_Geometry data owned by a different user may encounter Oracle bugs 4716096 and 5031836. This can cause the spatial index on the SDO_Geometry column to not be used.
For more information consult Oracle documentation on the following:
"5031836 - SECURE VIEW MERGING ON 10.2 PREVENTS DOMAIN INDEX USAGE"
"4716096 - DOMAIN INDEX NOT PERFORMED IN QUERY ON VIEW BY A DIFFERENT USER"
This issue is caused by changes that were made to view security in Oracle 10gR2.
To resolve this problem, do one of the following:
alter system set optimizer_secure_view_merging = FALSE
grant merge any view to <the users selecting the data>