FAQ: What is the st_geometry_index table?
What is the st_geometry_index table?
This table holds the spatial index information for an st_geometry column. The spatial index for an st_geometry type is a domain index referred to in the CREATE INDEX statement. The table also maintains information about the statistics of the domain index and spatial attribute which are used by the Oracle optimizer for determining the best access path for a query involving a spatial operator.
The following is a list of each attribute and its description:
Unqualified table name.
Name of the geometry column.
INDEX_ID NUMBER(38) NOT NULL
Uniquely identifies the domain index.
Grid type containing multilevel integer grid information SP_GRID_INFO is a GRID_TYPE column object consisting of three NUMBER grid values.
SRID NUMBER(38) NOT NULL
SRID and spatial reference information.
DML commit interval for spatial index rows; the number of rows affected before issuing a COMMIT. The default value is 1000.
Domain index version number.
Describes the index status; 1 = Active or 0 = Disabled. Loading can disable the index for performance reasons. The default is Active.
Name of the st_spatial_index (domain index).
Indicates weather the domain index is UNIQUE or NONUNIQUE.
Number of distinct domain index keys.
Depth of the domain index from its root block to its leaf blocks.
Number of leaf blocks for the domain index.
Indicates the amount of order of the rows in the table based on the values of the index. If the value is near the number of blocks, then the table is very well ordered. In this case, the index entries in a single leaf block tend to point to rows in the same data blocks. If the value is near the number of rows, then the table is very randomly ordered. In this case, it is unlikely that index entries in the same leaf block point to rows in the same data blocks.
Average number of features per grid cell.
Number of rows for the table containing the st_geometry and st_spatial_index.
Number of NULL st_geometry attribute values for the table containing the st_geometry and st_spatial_index.
Sample size used when collecting statistics (DBMS_STATS).
Date on which this table was most recently analyzed.
Indicates whether statistics were entered directly by the user (YES) or not (NO).
Indicates user defined operator selectivity and cost values. When set, defined values override derivied selectivity and system defined operator cost.