Oracle
Feature classes that use ST_Geometry storage use a separate table to store information for the spatial index. The spatial index table is named S<n>_IDX$, where <n> is the geometry index value for the table. The geometry index value is stored in the SDE.ST_GEOMETRY_COLUMNS geodatabase system table. The spatial index table is created as an Oracle Indexed Organized Table (IOT). The spatial index on the ST_Geometry attribute appears as A<n>_IX1 when viewed through Oracle Enterprise Manager. The value of <n> represents the LAYER_ID value stored in the LAYERS geodatabase system table.
Spatial indexes and ST_Geometry
https://oracle-base.com/articles/8i/index-organized-tables
Does that bolded blurb in the docs mean it’s possible to select the index data as rows in a query from the ST_GEOMETRY stpatial index?
Like this:
select * from _;
spatial_index_data
----------------------
[ST_GEOMETRY shape]
[ST_GEOMETRY shape]
[ST_GEOMETRY shape]
[ST_GEOMETRY shape]
…
Background: Get map to use function-based spatial index (ST_GEOMETRY)
Thanks.
