Under certain conditions, geometries existing near grid cell boundaries are not returned in a spatial query's result set.
The problem does not occur in all cases. Symptoms of the problem can include:
1. The spatial index is used to perform spatial queries such as, panning and zooming in ArcMap or identify, and features fail to draw at one extent but draw at other extents.
2. Selections produce a slightly smaller selection set than the selection envelope.
Starting with ArcSDE 9.2 Service Pack 5, a change was made to the Spatial Type for Oracle's spatial index (st_spatial_index) to correct a rounding condition when generating grid cell values. The rounding problem affected spatial indexes built prior to Service Pack 5.
The change in Service Pack 5 and all subsequent releases affects queries using existing spatial indexes and inserting new geometries into one of these spatial indexes.
This issue only impacts ST_GEOMETRY layers.
SQL> SELECT owner || '.' || index_name
ORDER BY owner, index;
ALTER INDEX <indexname> REBUILD;
To rebuild an index, the user must be the owner of the index or have been granted the Oracle system privilege ALTER ANY INDEX.